We (I work at Materialize) actually do support updates! Our CDC sources support them, as well as any source using an UPSERT envelope (more info here: https://ma

We (I work at Materialize) actually do support updates! Our CDC sources support them, as well as any source using an UPSERT envelope (more info here: https://materialize.com/docs/sql/create-source/text-kafka/#upsert-envelope-details https://materialize.com/docs/sql/create-source/text-kafka/#u...). As per your second point, I have a less awkward way for you! Materialize supports a top-k idiom (https://materialize.com/docs/sql/idioms/#top-k-by-group https://materialize.com/docs/sql/idioms/#top-k-by-group) that is hopefully a bit more clear.