They also do bunch of stuff that ClickHouse can't do, like correlated subqueries [1] or recursive CTEs. I kinda wish for a database with ClickHouse storage and

They also do bunch of stuff that ClickHouse can't do, like correlated subqueries [1] or recursive CTEs. I kinda wish for a database with ClickHouse storage and DuckDB optimizer. At least my experience with ClickHouse is that MergeTree is incredibly good at what it does, but the optimizer hurts. [1]: https://duckdb.org/2023/05/26/correlated-subqueries-in-sql.html https://duckdb.org/2023/05/26/correlated-subqueries-in-sql.h...