Query: app_service_web_app_input

select
  wa.title as label,
  lower(wa.id) as value,
  json_build_object(
    'subscription',
    s.display_name,
    'resource_group',
    wa.resource_group,
    'region',
    wa.region
  ) as tags
from
  azure_app_service_web_app as wa,
  azure_subscription as s
where
  lower(wa.subscription_id) = lower(s.subscription_id)
order by
  wa.title;