Query: iam_roles_for_ec2_instance

select
  distinct r.arn as role_arn
from
  aws_ec2_instance as i,
  aws_iam_role as r,
  jsonb_array_elements_text(instance_profile_arns) as instance_profile
where
  instance_profile = i.iam_instance_profile_arn
  and i.arn = $1;