Query: iam_role_inline_policy_count_for_role

select
  case
    when inline_policies is null then 0
    else jsonb_array_length(inline_policies)
  end as value,
  'Inline Policies' as label,
  case
    when inline_policies is null
    or jsonb_array_length(inline_policies) = 0 then 'ok'
    else 'alert'
  end as type
from
  aws_iam_role
where
  arn = $1