Correct. Under the hood, they work as insert triggers that automatically update the target whenever the source table changes. But it's more than that. One neat

Correct. Under the hood, they work as insert triggers that automatically update the target whenever the source table changes. But it's more than that. One neat thing is that it can handle incremental aggregations, such as AVG, SUM, and Percentiles, which would not be doable just with insert triggers. ClickHouse can do this because it stores the intermediate state of the aggregations in special Aggregate Function data types.