Pipelined SQL in ClickHouse 26.8

ClickHouse 26.8 introduces pipelined SQL, extending its existing FROM-first syntax with a |> operator that expresses queries as sequential transformations such as reading data, filtering rows, aggregating results, sorting, and limiting output. Using UK property-price data, the examples show that conventional SQL, FROM-first SQL, and pipeline syntax produce equivalent results, while pipelines can be easier to construct and inspect incrementally because every stage represents a complete intermediate query. ClickHouse translates pipelines into nested standard SQL internally, but optimizes the entire query rather than materializing every intermediate result. The new syntax supports EXTEND for adding computed columns while preserving existing ones and enables subsequent stages to reuse aggregation aliases, avoiding manually written subqueries or common table expressions. Pipeline-stage order is significant, as applying a limit before a later aggregation changes the underlying data and can produce nondeterministic results when no ordering is specified. Pipelines can also be used in subqueries, views, and INSERT ... SELECT operations, offering a processing-order alternative to conventional SQL without replacing it.

No tracked trend matches for this post yet.

Use this post, company, and trend context to find content marketing opportunities, perform competitive analysis, or address product feature gaps via the Plushcap MCP server or the Plushcap API.