Query: network_virtual_networks_for_network_firewall

with subnet_list as (
  select
    f.id as firewall_id,
    s.id as subnet_id
  from
    azure_firewall as f,
    jsonb_array_elements(ip_configurations) as c
    left join azure_subnet as s on lower(s.id) = lower(c -> 'subnet' ->> 'id')
  where
    lower(f.id) = $1
)
select
  lower(vn.id) as network_id
from
  azure_virtual_network as vn,
  jsonb_array_elements(subnets) as s,
  subnet_list as sub
where
  lower(s ->> 'id') = lower(sub.subnet_id);