First trick shows that update and delete should have a special syntax for when you really mean all rows:
UPDATE users SET email = lower(email)
This should return an error: "do you mean all rows?" UPDATE users all rows SET email = lower(email)
Or something like that.