I find myself caught out more often by incomplete where clauses — paranoid dry runs with rollbacks have saved me more than once.

Also fwiw DataGrip asks for confirmation before running an update or delete without a where clause