Hacker News new | ask | show | jobs
by ak4g 3703 days ago
Much like SELECT * or JOIN foo USING(bar), it's the kind of thing that greatly speeds up interactive queries, but shouldn't ever end up in source control.
1 comments

Why "JOIN foo USING (bar)" shouldn't be used?
Because with USING, you're precluded from using the full table.column identifier in your JOIN condition. Without that, a future ALTER TABLE that adds another "bar" column to an existing table in the FROM-list will cause a previously-working query to break.

https://gist.github.com/AdamG/1128b86fdafca1e53a4bd5253a6882...