Query: cosmosdb_account_capabilities

select
  c ->> 'name' as "Capability",
  'Enabled' as "State"
from
  azure_cosmosdb_account,
  jsonb_array_elements(capabilities) c
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3);