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)

buro9 7 months ago | parent | prev | next [-]

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

	▲	marcosdumay 7 months ago \| parent [-]
		But requiring them is fine too. Even more on Postrges, that has booleans.

ahoka 7 months ago | parent | prev [-]

And queries should start with WHERE.

FROM, then WHERE, then SELECT

	▲	Jabbles 7 months ago \| parent \| next [-]
		Pipe Syntax In SQL https://research.google/pubs/sql-has-problems-we-can-fix-the... https://news.ycombinator.com/item?id=41338877
	▲	7 months ago \| parent \| prev \| next [-]
		[deleted]
	▲	hamandcheese 7 months ago \| parent \| prev [-]
		This is the way.

7 months ago | parent | prev [-]

[deleted]