We've added a new Postgres extension.
pg_strict
pg_strict blocks dangerous queries before they run. It prevents common mistakes like UPDATE or DELETE statements without WHERE clauses that would affect every row in a table.
The extension is configured per-role, so different users can have different settings. Each setting supports three modes: off, warn, or on. For intentional bulk operations, you can temporarily override the setting within a transaction using SET LOCAL.