TLDR DevOps · NEWS & TRENDS
PIPELINED SQL IN CLICKHOUSE 26.8
Summary from the TLDR DevOps newsletter
ClickHouse 26.8 adds pipelined SQL with a new |> operator that lets queries be written as an explicit sequence of transformations instead of relying on nested subqueries or CTEs. Each stage passes its result to the next, making multi-step filtering, aggregation, sorting, and limiting easier to read and compose.