Query: ibm_compute_instance_network_interfaces

select
  i ->> 'name' as "Name",
  i ->> 'id' as "ID",
  i ->> 'primary_ipv4_address' as "Primary IPv4 Address",
  i -> 'subnet' ->> 'name' as "Subnet Name",
  i -> 'subnet' ->> 'id' as "Subnet ID"
from
  ibm_is_instance,
  jsonb_array_elements(network_interfaces) as i
where
  crn = $1
order by
  i ->> 'name';