Optimize FINAL Queries with PREWHERE Column Movement in ClickHouse
Official CH changelog text
Optimize performance of queries like SELECT ... FINAL ... WHERE. Now in queries with FINAL it's allowed to move to PREWHERE columns, which are in sorting key. #21830 (foolchi).