Query: network_route_tables_for_network_virtual_network

with subnet_list as (
  select
    lower(s ->> 'id') as subnet_id
  from
    azure_virtual_network as v,
    jsonb_array_elements(v.subnets) as s
  where
    lower(v.id) = $1
    and v.subscription_id = split_part($1, '/', 3)
)
select
  lower(r.id) as route_table_id
from
  azure_route_table as r,
  jsonb_array_elements(r.subnets) as sub
where
  lower(sub ->> 'id') in (select subnet_id from subnet_list);