Query: rds_db_instance_public_status

with db_instances as (
  select
    case
      when publicly_accessible is null or (not publicly_accessible) then 'private'
      else 'public'
    end as visibility
  from
    aws_rds_db_instance
)
select
  visibility,
  count(*)
from
  db_instances
group by
  visibility;