Query: activedirectory_groups_for_user

select
  g.display_name as "Display Name",
  g.id as "ID",
  g.is_subscribed_by_mail as "Is Subscribed By Mail",
  g.expiration_date_time as "Expiration Time"
from
  azuread_group as g,
  jsonb_array_elements(member_ids) as m
where
  trim((m::text), '""') = split_part($1, '/', 1)
  and g.tenant_id = split_part($1, '/', 2)
order by
  g.display_name ;