Query: vpc_routes_detail

select
  route_table_id as "Route Table ID",
  name as "Name",
  r ->> 'Status' as "Status",
  r ->> 'InstanceId' as "Gateway",
  r ->> 'DestinationCidrBlock' as "Destination CIDR",
  case
    when v is null then vpc_id
    else v
  end as "Associated To"
from
  alicloud_vpc_route_table,
  jsonb_array_elements(route_entries) as r,
  jsonb_array_elements_text(vswitch_ids) as v
where
  vpc_id = $1
order by
  route_table_id,
  "Associated To";