Query: activedirectory_directory_roles_for_user

select
  role_name as "Role Name",
  id as "Role ID"
from
  (
    select
      dr.display_name as role_name,
      dr.id as id
    from
      azuread_directory_role as dr,
      jsonb_array_elements(member_ids) as m
    where
      trim((m :: text), '""') = $1
    union
    select
      dr.display_name as role_name,
      dr.id as id
    from
      azuread_directory_role as dr,
      jsonb_array_elements(member_ids) as m
    where
      trim((m :: text), '""') in (
        select
          g.id as id
        from
          azuread_group as g,
          jsonb_array_elements(member_ids) as m
        where
          trim((m :: text), '""') = $1
      )
  ) data
order by
  role_name;