[asah]

Subqueries, named VIEWs, CTEs, etc all make SQL compostable ?

[radiowave]

Yes, 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]

Many of the modern constructs weren’t there in 1984’s SQL, which this story describes; they were added later to address composability issues.