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

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