The standard answer on this is that you shouldn't be using <code>SELECT *</code> at all in production code. That shortcut can be useful in quick scripts and debugging, but has nasty results when used in a program you're not going to look at for years. The most obvious is that if you come back to an old project and add an extra column to a table, you then have to change every <code>SELECT *</code>.