Why even add the pipe operator? If the DB engine is executing the statement out ... | Hacker News

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

		philippta on Aug 29, 2024 \| parent \| context \| favorite \| on: Google's new pipe syntax in SQL Why even add the pipe operator? If the DB engine is executing the statement out of order, why not allow the statement to be written in any order and let itself figure it out?

bvrmn on Aug 29, 2024 | [–]

Aggregations could be non-commutative in general case and order is important. Filters before and after grouping are also tied to a particular place in the pipeline.

self on Aug 29, 2024 | [–]

> Why even add the pipe operator?

To make it easier for humans to read/write the queries.

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