Query: s3_bucket_lifecycle_table

select
  b.name as "Name",
  case
    when b.versioning_enabled then 'Enabled'
    else null
  end as "Versioning",
  case
    when b.versioning_mfa_delete then 'Enabled'
    else null
  end as "Versioning MFA Delete",
  a.title as "Account",
  b.account_id as "Account ID",
  b.region as "Region",
  b.arn as "ARN"
from
  aws_s3_bucket as b,
  aws_account as a
where
  b.account_id = a.account_id
order by
  b.name;