Coming soon on ClickHouse ® : Window functions

ClickHouse® has introduced window functions as an experimental feature, enabling users to perform calculations across related table rows without grouping them into a single output row, thereby simplifying query writing and expanding functional possibilities. These functions, already familiar to users of databases like Postgres and MySQL, allow for cumulative sums, averages, moving counts, and more advanced operations, utilizing clauses such as WINDOW, PARTITION BY, and RANGE to define how data is processed. Additionally, ClickHouse® supports ranking functions like RANK, ROW_NUMBER, and DENSE_RANK, with recent updates addressing issues related to sorting with partition expressions. The roadmap for ClickHouse® includes promising features like enhanced support for nested and semi-structured data, separation of storage and compute, a PostgreSQL table engine, projections for efficient aggregations, and improved backup capabilities. Tinybird offers dynamic endpoints for real-time analytics on ClickHouse® data, providing additional utility for users looking to leverage these new features.