Based on feedback from working with customers there is often a blanket apprehension to using FINAL, although it can be useful in many cases.

We should:

• go through the docs and identify places where this is discussed and soften the language or explain when FINAL can be used.

One possibility is that there is confusion between OPTIMIZE FINAL and FINAL. Contrast for example https://clickhouse.com/docs/optimize/avoidoptimizefinal and https://clickhouse.com/docs/sql-reference/statements/select/from#final-modifier, we might consider naming this best practice differently.