TLDR Avoid using SELECT * in SQL queries, even for single-column tables, as it can lead to inefficient database operations and performance issues. Explicitly selecting only necessary columns allows for better optimization, reducing overhead related to deserialization, network costs, and query unpredictability. Specific column selection also facilitates easier code maintenance and database schema updates.
🔗 https://medium.com/@hnasr/avoid-select-even-on-a-single-column-tables-d6deed7b4aee