connect 'jdbc:rest:https://graph.microsoft.com/v1.0|spec=graph-spec.json,auth=oauth2,tenant=YOUR-TENANT-ID,clientId=YOUR-CLIENT-ID,clientSecret=YOUR-CLIENT-SECRET,scope=https://graph.microsoft.com/.default'

status

SELECT id, "displayName", mail, "userPrincipalName" FROM users;

SELECT id, "displayName", mail FROM users
  FILTER startswith(displayName,'A') AND accountEnabled eq true;

SELECT id, "displayName", "mailEnabled" FROM groups
  FILTER mailEnabled eq true;

quit
