[zmgsabst]

I’m not sure what you mean by “composable” here — could you elaborate?

[mamcx]

Composable is the ability to define things in the small and combine with confidence.

SQL not allow this:

    by_id := WHERE id = $1
     
    SELECT * | by_id

[simonw]

CTEs provide some pretty useful composability for SQL queries. I find myself using them all the time.