Support for Recursive CTEs in ClickHouse

Why it matters

This feature allows users to perform recursive queries directly in ClickHouse, solving problems that require hierarchical or iterative data processing, such as traversing graph structures or hierarchical relationships, which were previously difficult or impossible to express in a single query.

How to use it

Users can utilize recursive CTEs by defining a CTE with the WITH RECURSIVE clause followed by the recursive query. This enables writing queries where the CTE references itself to perform recursion.