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