Query: ibm_is_volume_attached_instances

select
  a -> 'instance' ->> 'name' as "Instance Name",
  a -> 'instance' ->> 'id' as "Instance ID",
  a -> 'delete_volume_on_instance_delete' as "Delete Volume On Instance Delete",
  a -> 'instance' ->> 'crn' as "Instance CRN"
from
  ibm_is_volume as v,
  jsonb_array_elements(volume_attachments) as a
where
  v.crn = $1
order by
  a -> 'instance' ->> 'name';