Query: oss_bucket_lifecycle_policy

select
  r ->> 'ID' as "ID",
  r ->> 'AbortMultipartUpload' as "Abort Multipart Upload",
  r ->> 'Expiration' as "Expiration",
  r ->> 'NonVersionExpiration' as "Non Version Expiration",
  r ->> 'NonVersionTransition' as "Non Version Transition",
  r ->> 'Prefix' as "Prefix",
  r ->> 'NonVersionTransitions' as "Non Version Transitions",
  r ->> 'Status' as "Status",
  r ->> 'Tags' as "Tags",
  r ->> 'Transitions' as "Transitions",
  r ->> 'XMLName' as "XML Name"
from
  alicloud_oss_bucket,
  jsonb_array_elements(lifecycle_rules) as r
where
  arn = $1
order by
  r ->> 'ID';