Many use cases can be addressed by using ReplacingMergeTree and such, so even when you need updates you can get them relatively cheaply