Query: activedirectory_group_type

select
  'Group Type' as label,
  case
    when security_enabled then 'Security'
    else 'Microsoft 365'
  end as value
from
  azuread_group
where
  id = $1;