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
order by
  name;