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), '""') = split_part($1, '/', 1)
  and dr.tenant_id = split_part($1, '/', 2)
order by
  dr.display_name;