TPCDS 49, 70, 72, 86 Failed

[djouallah]

Describe the bug

from the 99 queries, 4 queries still fail

To Reproduce

https://drive.google.com/file/d/1NmrDyFRVNSCCsatwm77sery_s0yCaB-1/view?usp=sharing

Expected behavior

I expect everything to run

Additional context

No response

[alamb]

Thanks @djouallah -- I wonder if you could look into the queries that are failing and see if there are existing issues that cover them or if we should file new ones?

[akoshchiy]

The Q70 is failing because of compound expr in ORDER BY. I think the problem is somewhere in rewrite_in_terms_of_projection function. I've described the simple reproduce in #14459 and trying to fix it :)