Query: s3_bucket_lifecycle_policy

select
  r ->> 'ID' as "ID",
  r ->> 'AbortIncompleteMultipartUpload' as "Abort Incomplete Multipart Upload",
  r ->> 'Expiration' as "Expiration",
  r ->> 'Filter' as "Filter",
  r ->> 'NoncurrentVersionExpiration' as "Non-current Version Expiration",
  r ->> 'Prefix' as "Prefix",
  r ->> 'Status' as "Status",
  r ->> 'Transitions' as "Transitions"
from
  aws_s3_bucket,
  jsonb_array_elements(lifecycle_rules) as r
where
  arn = $1
order by
  r ->> 'ID';