Query: iam_policies_for_iam_role

select
  policy_arn
from
  aws_iam_role,
  jsonb_array_elements_text(attached_policy_arns) as policy_arn
where
  arn = $1;