Query: network_express_route_circuit_peerings_primary

select
  name as "Name",
  replace(jsonb_path_query(peerings, '$.properties.primaryAzurePort')::text, '"', '') as "Primary Azure Port",
  replace(jsonb_path_query(peerings, '$.properties.primaryPeerAddressPrefix')::text, '"', '') as "Primary Peer Address Prefix"
from
  azure_express_route_circuit
where
  lower(id) = $1
  and subscription_id = split_part($1, '/', 3)
order by
  name;