MSSQL DBA, MySQL dev, apprentice PostgreSQL DBA · Author has 9.2K answers and 14.3M answer views · 11y ·
Some complaints from the top of my head:
- SQL is generally awkward to format due to the syntax.
- You have to repeat a select clause in the "group by" clause without a referencing possibility.
- In an update statement, tables appear first, then columns; in queries it is the the other way round (because SQL syntax is driven by natural language). I would like them to conform so it's easier to do quick checks/tests.
- Expressions that occur several times in a query (e.g. conditions that occur in both branches of a union) must be typed twice, with no abstraction possibility.
2.3K views ·
View upvotes
· 1 of 5 answers