odbtools/odbctest/mql/0/json/2.mql

{
"sql": "SELECT t001.username,t002.fullname,t001.grpset,t002.member,t001.email FROM /matrix/ldap t001 JOIN /matrix/group t002 ON exists (select 1 from json_each(t001.grpset) where value=t002.fullname)"
}