All SQL syntaxes (Clickhouse, Oracle, PSG, etc) have an elementary WITH section - which allows you to reuse intermediate results that you can not use in the final set of columns
This functionality is EXTREMELY necessary, now it is extremely difficult to use the current DQL without reusing intermediate values