Except for a few unusual cases, I agree that select * should be forbidden in production code, but it is extremely useful for interactively exploring data, debugging, reverse-engineering etc. And, I’ve often wished for a way to select all columns except for one or two. In the past, I’ve created scripts that generate a list of all the columns in a table or view (from the data dictionary) that I can quickly edit to make the query I want. But, that slows me down.