Query: network_virtual_networks_for_network_interface

with subnet_list as(
  select
    ni.id as network_interface_id,
    c -> 'properties' -> 'subnet' ->> 'id' as subnet_id
  from
    azure_network_interface as ni,
    jsonb_array_elements(ip_configurations) as c
    left join azure_subnet as s on lower(s.id) = lower(c -> 'properties' -> 'subnet' ->> 'id')
  where
    lower(ni.id) = $1
)
select
  lower(v.id) as virtual_network_id
from
  azure_virtual_network as v,
  jsonb_array_elements(subnets) as s,
  subnet_list as l
where
  lower(l.subnet_id) = lower(s ->> 'id');