Query: ec2_ami_shared_with

with sharing as (
  select
    lp
  from
    aws_ec2_ami as ami,
    jsonb_array_elements(ami.launch_permissions) as lp
  where
    image_id = $1
) -- Accounts
select
  lp ->> 'UserId' as "Shared With"
from
  sharing
where
  lp ->> 'UserId' is not null -- Organization
union all
select
  lp ->> 'OrganizationArn' as "Shared With"
from
  sharing
where
  lp ->> 'OrganizationArn' is not null -- Organizational Unit
union all
select
  lp ->> 'OrganizationalUnitArn' as "Shared With"
from
  sharing
where
  lp ->> 'OrganizationalUnitArn' is not null