Query: iam_users_with_inline_policy

with inline_compliance as (
  select
    arn,
    case
      when jsonb_array_length(inline_policies) > 0 then 'with inline policies'
      else 'no inline policies'
    end as has_inline
  from
    aws_iam_user
)
select
  has_inline,
  count(*)
from
  inline_compliance
group by
  has_inline;