Query: network_express_route_circuit_peerings_secondary

select
  name as "Name",
  replace(
    jsonb_path_query(peerings, '$.properties.secondaryAzurePort') :: text,
    '"',
    ''
  ) as "Secondary Azure Port",
  replace(
    jsonb_path_query(
      peerings,
      '$.properties.secondaryPeerAddressPrefix'
    ) :: text,
    '"',
    ''
  ) as "Secondary Peer Address Prefix"
from
  azure_express_route_circuit
where
  lower(id) = $1
order by
  name;