3 ms·
Subqueries, named VIEWs, CTEs, etc all make SQL compostable ?
by asah 6y ago
Subqueries, named VIEWs, CTEs, etc all make SQL compostable ?
- radiowave 6y agoYes, but it's extremely clunky. The number of times I've had to write out a whole chain of CTEs just because I wanted to apply one window function to the output of another. In which context, "compostable" is a fantastic Freudian typo.
- beagle3 6y agoMany of the modern constructs weren’t there in 1984’s SQL, which this story describes; they were added later to address composability issues.