Query: network_express_route_circuit_peerings

select
  name as "Name",
  replace(jsonb_path_query(peerings, '$.properties.azureASN')::text, '"', '') as "Azure ASN",
  replace(jsonb_path_query(peerings, '$.properties.connections')::text, '"', '') as "Connections",
  replace(jsonb_path_query(peerings, '$.properties.gatewayManagerEtag')::text, '"', '') as "Gateway Manager Etag",
  replace(jsonb_path_query(peerings, '$.properties.peerASN')::text, '"', '') as "Peer ASN",
  replace(jsonb_path_query(peerings, '$.properties.peeringType')::text, '"', '') as "Peering Type",
  replace(jsonb_path_query(peerings, '$.properties.state')::text, '"', '') as "State",
  replace(jsonb_path_query(peerings, '$.properties.vlanId')::text, '"', '') as "Vlan ID"
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  name;