3 ms·
Any "improved SQL" could take some inspiration from .net's Linq. Some conveniences in Linq compared to SQL: - From clause before the select clause. Makes it po
by goto11 6y ago
Any "improved SQL" could take some inspiration from .net's Linq. Some conveniences in Linq compared to SQL:
- From clause before the select clause. Makes it possible to use code completion in the select clause.
- Instead of the having clause, you just have a new where-clause after a group-by, which operates on the groupings.
- let-clauses where you can define expression which can then be re-used in the following clauses.
- composability, so you can have arbitrary many select/group/where/join/let clauses in any order following the initial from-clause.