Every story and comment from the Hacker News API, in a layout borrowed from 2001.
A comment on We Can Do Better Than SQL (2019).
- 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.
There are no comments on this comment yet.
- 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.