Query: ec2_instances_for_ebs_volume

select
  e.arn as instance_arn
from
  aws_ebs_volume as v,
  jsonb_array_elements(attachments) as a,
  aws_ec2_instance as e
where
  a ->> 'InstanceId' = e.instance_id
  and v.arn = $1;