Query: iam_policy_input

with policies as (
  select
    title as label,
    arn as value,
    json_build_object(
      'account_id', account_id
    ) as tags
  from
    aws_iam_policy
  where
    not is_aws_managed
  union all select
    distinct on (arn)
    title as label,
    arn as value,
    json_build_object(
      'account_id', 'AWS Managed'
    ) as tags
  from
    aws_iam_policy
  where
    is_aws_managed
)
select
  *
from
  policies
order by
  label;