Hacker News Reader

I've spent most of my career working with teams that mostly write SQL code, at multiple companies.

Except for very rare fringe cases, using "SELECT *" in production code is universally considered bad practice.

Select * is pretty standard for wide table queries like they are used in Data Analytics teams regularly. Because you really want ALL columns, even new ones without going back to fix all 300+ dashboards.

Yep. I think the others commenting here aren't using SQL for analytics and don't recognize the importance of select * in that context.

Reply on news.ycombinator.com