Query: activedirectory_group_directory_roles

select
  dr.display_name as "Display Name",
  dr.id as "ID"
from
  azuread_directory_role as dr,
  jsonb_array_elements(member_ids) as m
where
  trim((m :: text), '""') = $1
order by
  dr.display_name;