Hacker News Reader

Agreed, I've long been thinking that DELETE should require a WHERE clause.

If you really want to just delete everything, just do WHERE 1=1.

It would be nice if there was a psql option that would warn you if you're about to do any kind of update, delete or insert without doing a BEGIN;

(You could always set autocommit=false, which forces you to explicitly commit or rollback every action, but that has its own baggage)

UPDATEs should require a WHERE clause too.

At which point we could just say all SQL should have a WHERE clause.

I think SELECTs without WHERE clauses are fine

But requiring them is fine too. Even more on Postrges, that has booleans.

And queries should start with WHERE.

FROM, then WHERE, then SELECT

This is the way.

Pipe Syntax In SQL