Query: compute_network_peering

select
  p ->> 'name' as "Name",
  p ->> 'state' as "State",
  p ->> 'stateDetails' as "State Details",
  p ->> 'autoCreateRoutes' as "Auto Create Routes",
  p ->> 'exchangeSubnetRoutes' as "Exchange Subnet Routes",
  p ->> 'exportSubnetRoutesWithPublicIp' as "Export Subnet Routes With Public IP"
from
  gcp_compute_network,
  jsonb_array_elements(peerings) as p
where
  id = (split_part($1, '/', 1))::bigint
  and project = split_part($1, '/', 2);