You can somewhat achieve a pipelined like system in sql by breaking down your st... | Hacker News

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

		1899-12-30 8 months ago \| parent \| context \| favorite \| on: Pipelining might be my favorite programming langua... You can somewhat achieve a pipelined like system in sql by breaking down your steps into multiple CTEs. YMMV on the performance though.

infogulch 8 months ago [–]

Yeah, the way to get logical pipelining in SQL without CTEs is nested subqueries in the FROM clause. Unfortunately, the nesting is syntactically ugly and confusing to read which is basically the whole idea behind pipeline syntax.

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