Query: rds_db_instance_logging_table

select
  i.db_instance_identifier as "DB Instance Identifier",
  case
    when
      ( i.engine like any (array ['mariadb', '%mysql']) and i.enabled_cloudwatch_logs_exports ?& array ['audit','error','general','slowquery'] ) or ( i.engine like any (array['%postgres%']) and i.enabled_cloudwatch_logs_exports ?& array ['postgresql','upgrade'] ) or
      ( i.engine like 'oracle%' and i.enabled_cloudwatch_logs_exports ?& array ['alert','audit', 'trace','listener'] ) or
      ( i.engine = 'sqlserver-ex' and i.enabled_cloudwatch_logs_exports ?& array ['error'] ) or
      ( i.engine like 'sqlserver%' and i.enabled_cloudwatch_logs_exports ?& array ['error','agent'] )
    then  'Enabled' else null end as "Logging",
  i.engine as "Engine",
  i.enabled_cloudwatch_logs_exports as "Enabled CW Logs Exports",
  a.title as "Account",
  i.account_id as "Account ID",
  i.region as "Region",
  i.arn as "ARN"
from
  aws_rds_db_instance as i,
  aws_account as a
where
  i.account_id = a.account_id
order by
  i.db_instance_identifier;