3 ms·

One thing I don't like about using `SELECT *` in code is that it hides information from the your future self. When I come back to a piece of code in a couple o

One thing I don't like about using `SELECT *` in code is that it hides information from the your future self. When I come back to a piece of code in a couple of years time, knowing which columns I'm selecting helps provide context for the code using that query.

flatiron 5y ago
People say what they will with JPA but at least it makes “context for the code” very clear.
temp8964 5y ago
Yes. But there are times it is by design for the sql query to be agnostic about the database structure or the data model. That's when `SELECT *` becomes very useful.