Aliases rarely add clarity in my experience. An alias is just an extra lookup when I need context. It’s a waste of mental swap space. Inlined subqueries are

Aliases rarely add clarity in my experience. An alias is just an extra lookup when I need context. It’s a waste of mental swap space. Inlined subqueries are creating entirely new projections so they need descriptive names. If you are doing this you should consider a WITH anyway.