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.

Consider applying for YC's Fall 2026 batch! Applications are open till July 27.
Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact