Ability to protect a table

[steve-chavez]

Problem

Doing DROP TABLE on a table with a lot of data is usually a big mistake. This can even happen unintentionally with some migration systems.

See https://old.reddit.com/r/Supabase/comments/139wxfo/prevent_dropping_of_tables/

Solution

Only allow dropping the table if the table has a small amount of data. This should be configurable.

The logic can be:

• User does DROP TABLE tbl. We query the estimated rows this table has, if larger than X refuse and say "Denied. If you're sure about this TRUNCATE the table first". Once truncated it will be lower than X rows so just allow dropping then.
• For cases that escape this logic, there's backups. Which should be fast to restore bc there are few rows.