Query: ram_policy_input

with policies as (
  select
    title as label,
    policy_name as value,
    json_build_object('account_id', account_id) as tags
  from
    alicloud_ram_policy
  where
    policy_type != 'System'
  union all
  select
    distinct on (policy_name) title as label,
    policy_name as value,
    json_build_object('account_id', 'Alicloud Managed') as tags
  from
    alicloud_ram_policy
  where
    policy_type = 'System'
)
select
  *
from
  policies
order by
  label;