Query: network_load_balancers_for_compute_virtual_machine_scale_set_vm

with compute_virtual_machine_scale_set_network_interface as (
  select
    nic.id as nic_id,
    c ->> 'id' as config_id
  from
    azure_compute_virtual_machine_scale_set_network_interface as nic,
    jsonb_array_elements(ip_configurations) as c
  where
    lower(nic.virtual_machine ->> 'id') = $1
),
backend_address_pool as (
  select
    lower(p.id) as id
  from
    azure_lb_backend_address_pool as p,
    jsonb_array_elements(backend_ip_configurations) as c
  where
    c ->> 'id' in (
      select
        config_id
      from
        compute_virtual_machine_scale_set_network_interface
    )
)
select
  lower(lb.id) as lb_id
from
  azure_lb as lb,
  jsonb_array_elements(backend_address_pools) as p
where
  lower(p ->> 'id') in (
    select
      id
    from
      backend_address_pool
  )