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.
Many of the modern constructs weren’t there in 1984’s SQL, which this story describes; they were added later to address composability issues.