This is a tension between application-sql and exploration-sql.

When building a data application, say a reporting tool, you want the code to be explicit. It is much easier to read if all columns are written out.

If you are ad-hoc exploring data, this is a pain.