Profile photo for Joachim Pense

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.

View 4 other answers to this question
About · Careers · Privacy · Terms · Contact · Languages · Your Ad Choices · Press ·
© Quora, Inc. 2025