Designer should provide an option to expand the column names by default in the transformation.

When a default transformation is created when a virtual base table is created, it always creates a table with

select * from foo

some time it is desirable to generate to query in fully extended format as

select c1, c2, ... from foo

This could be designed as "preference" for Designer transformation.