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), '""') = $1
order by
  g.display_name;