3 ms·

I don't think SQL does compose well. Queries aren't first-class values in SQL. I can write a query that queries the result of another query, but I can't store

I don't think SQL does compose well. Queries aren't first-class values in SQL. I can write a query that queries the result of another query, but I can't store a query and then pass that somewhere to query from.

pmontra 6y ago
Maybe the WITH statement and CTEs can help you, if I understood correctly your complaint. Check the example at the beginning of https://www.postgresql.org/docs/13/queries-with.html https://www.postgresql.org/docs/13/queries-with.html