The difference in impact between DELETE * FROM tbl and DELETE * FROM tbl WHERE id > 1 isn't enough to warrant a change to the standard in my opinion.

The difference in impact between DELETE * FROM tbl and DELETE * FROM tbl WHERE id > 1 isn't enough to warrant a change to the standard in my opinion. Data loss and corruption risks need other forms of mitigation and they'll cover the unconstrained cases as well.