Query: rds_db_instance_deletion_protection_status

with db_instances as (
  select
    case
      when deletion_protection then 'enabled'
      else 'disabled'
    end as visibility
  from
    aws_rds_db_instance
)
select
  visibility,
  count(*)
from
  db_instances
group by
  visibility;