I agree wildcards are better avoided but so are column orders in result extraction. They are a source of bugs and much review work when changes are made.
If I had to choose (which usually isn't necessary) I'd say wildcards are the lesser evil.
If I had to choose (which usually isn't necessary) I'd say wildcards are the lesser evil.
Sure, but depending on number of records and/or implementation of the name lookup, it can add up over a large resultset, or have a slightly cost over many smaller queries.
Mind you, I think -most- implementations are smart enough to only need to do the lookup once for a returned datareader, but the cost is still there.
While I agree, there are some languages + db drivers where this is your only choice unless you roll your own. Go's sql package relies on order in the Scan method, for example.