How DuckDB Runs Recursive CTEs Faster
The upcoming DuckDB v2.0 introduces physical execution changes to run recursive CTEs faster. By explicitly assigning scopes and reusing pipeline executors, the engine avoids repeatedly paying for pipeline scheduling and operator setup across iterations.