[magicalhippo]

I got descriptive table names like WhsTransactionGoodsItems and WhsTransactionGoodsItemPackages.

I feel it would be rather noisy to have to specify such table names in front of the 15+ column references in a query, compared to using aliases.

Then again I've never had to diff the result sets, so I guess our usage is quite different.

[mulmen]

My editor has tab completion, it's not like you have to type every character. I prefer it for readability but it's definitely debatable.

[magicalhippo]

Readability is weird heh, I'm exactly the opposite. For me long lines become a blur, so better to have a short alias.

[mulmen]

I know what you mean. I think this is really a matter of readability vs comprehension. I want all the context on one line so I can understand it, even if that does technically make it harder to read that line.

This is especially a problem in huge queries.