Query: ibm_compute_instance_disks

select
  d ->> 'name' as "Name",
  d ->> 'id' as "ID",
  d ->> 'size' as "Size",
  d ->> 'interface_type' as "Interface Type",
  d ->> 'resource_type' as "Resource Type",
  d ->> 'created_at' as "Create Time",
  d ->> 'href' as "HREF"
from
  ibm_is_instance,
  jsonb_array_elements(disks) as d
where
  crn = $1
order by
  d ->> 'name';