Re:Best practices for writing SQL queries
by gizmodo59 on Saturday April 10, 2021 @01:55PM
(#26763459)
Even there someone needs to read them eventually than just the person who wrote it. Single letter aliases are just evil. In some ways it’s the same as doing: String x = “Hello”
[ Parent
| on HN ]
Re:Best practices for writing SQL queries
by dragonwriter on Saturday April 10, 2021 @02:10PM
(#26763595)
> Even there someone needs to read them eventually than just the person who wrote it.
That’s not an argument against table aliases, its an argument against unclear table aliases.
Single letter table aliases are better than just using unqualified column names, both of which are worse than table aliases guided by the same naming rules you’d use for semantically-meaningful identifiers in regular program code.