I don't think SQL does compose well. Queries aren't first-class values in SQL. I... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		TheCoelacanth on April 21, 2021 \| parent \| context \| favorite \| on: Prisma – ORM for Node.js and TypeScript 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 on April 21, 2021 [–]

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

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact