>functionality to define aliases for complex expressions and then reuse those through a query What's an example of what you're trying to do? I think views, use

>functionality to define aliases for complex expressions and then reuse those through a query What's an example of what you're trying to do? I think views, user-defined functions, routines, and select aliases would cover all the bases...