The work on materialized views in ClickHouse, from my perspective, is still quite rudimentary. If interested, I suggest looking into the materialized views of S

The work on materialized views in ClickHouse, from my perspective, is still quite rudimentary. If interested, I suggest looking into the materialized views of StarRocks. StarRocks' materialized views not only support multi-table joins and incremental updates but can also automatically rewrite query requests, so you don't have to modify your SQL statements at all. https://celerdata.com/glossary/materialized-view https://celerdata.com/glossary/materialized-view