select * is ANSI standard.

And there is places where it shouldn't matter what is returned - as it is up to the DBMS to handle.

An example is the following: -

select...