Query: ram_all_policies_for_group

select
  policies ->> 'PolicyName' as "Name",
  policies ->> 'PolicyType' as "Type",
  policies ->> 'DefaultVersion' as "Default Version",
  policies ->> 'AttachDate' as "Attachment Date"
from
  alicloud_ram_group,
  jsonb_array_elements(attached_policy) as policies
where
  arn = $1
  and account_id = split_part($1,':',4);