Aliases in WITH Statement Now Supported in Index Analysis
Official CH changelog text
Aliases declared in WITH statement are properly used in index analysis. Queries like WITH column AS alias SELECT ... WHERE alias = ... may use index now. #18896 (Amos Bird).