Agree. In my experience people use aliases to use aliases. They know them but don't understand them.

Aliases are the SQL equivalent of ternary operators. Are you trying to write clean code or are you trying to express to other people you know things?