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;