Requiring the WHERE clause in DELETE FROM would probably have avoided some very expensive disasters, too... I'll just come out and say it, modern SQL amazing a

Requiring the WHERE clause in DELETE FROM would probably have avoided some very expensive disasters, too... I'll just come out and say it, modern SQL amazing and powerful but it is not a good language. The language spec shows a weird obsession with "natural language" style programming, sometimes at the cost of safety, consistency and expressiveness. It is not a good language to generate by code, nor to use directly on the command line. It is not a good language to efficiently access your stored data, nor to express relational algebra. But you're going to have to learn it, and modern databases do amazing things with it to make it work.