Query: network_virtual_networks_for_network_security_group

with subnet_list as (
  select
    nsg.id as nsg_id,
    sub ->> 'id' as subnet_id
  from
    azure_network_security_group as nsg,
    jsonb_array_elements(subnets) as sub
  where
    lower(nsg.id) = $1
)
select
  lower(vn.id) as network_id
from
  azure_virtual_network as vn,
  jsonb_array_elements(subnets) as sub
  join subnet_list as s on lower(s.subnet_id) = lower(sub ->> 'id')
where
  lower(s.nsg_id) = $1;