Query: network_virtual_networks_for_app_service_web

select
  lower(id) as virtual_network_id
from
  azure_virtual_network,
  jsonb_array_elements(subnets) as sub
where
  lower(sub ->> 'id') in (
    select
      lower(vnet_connection -> 'properties' ->> 'vnetResourceId')
    from
      azure_app_service_web_app
    where
      lower(id) = $1
  );