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
    and nsg.subscription_id = split_part($1, '/', 3)
) 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
    and vn.subscription_id = split_part($1, '/', 3);