Query: blockstorage_volume_attached_droplets

select
  d.name as "Droplet Name",
  d.id as "Droplet ID",
  d.created_at as "Create Time",
  d.urn as "Droplet URN",
  d.status as "Droplet Status"
from
  digitalocean_volume as v,
  jsonb_array_elements(v.droplet_ids) as droplet_id,
  digitalocean_droplet as d
where
  d.id = droplet_id::bigint
  and v.urn = $1
order by
  d.name;