Query: network_virtual_networks_for_network_load_balancer

with backend_address_pools as (
  select
    lb.id as lb_id,
    p.id as backend_address_id,
    p.load_balancer_backend_addresses as load_balancer_backend_addresses
  from
    azure_lb as lb,
    jsonb_array_elements(backend_address_pools) as b
    left join azure_lb_backend_address_pool as p on lower(p.id) = lower(b ->> 'id')
  where
    p.load_balancer_backend_addresses is not null
    and lower(lb.id) = $1
),
load_balancer_backend_addresses_list as (
  select
    lb_id,
    a -> 'properties' -> 'virtualNetwork' ->> 'id' as vn_id
  from
    backend_address_pools,
    jsonb_array_elements(load_balancer_backend_addresses) as a
  where
    a -> 'properties' -> 'virtualNetwork' ->> 'id' is not null
)
select
  lower(vn.id) as virtual_network_id
from
  azure_virtual_network as vn
  right join load_balancer_backend_addresses_list as b on lower(b.vn_id) = lower(vn.id)