ClickHouse does allow delete and update operations. They are just asynchronous functions.

I use them every now and then, but I prefer working with partition strategies when I have to these programmatically.