In the interest of keeping the steps required to extract data to minimum I'd like to see the following change in SQL steps that are converted to Pass-Through. Allow for double mapping in the selection query, let me explain.
When you flip the switch in a transformation to pass-through typically the SQL query takes this form:
Connect to (<db-connect-string> as ODBC;
Create Table xyz as
Select * from Connection to ODBC
(Select a, b, c, d From dbo.dm.table);
Disconnect from ODBC;
Currently in the mapping tab you can only map what goes on inside the database, I would like to see that we can also manipulate the "Select * " selection clause so as the data is parsed over to SAS we can immediately apply mapping changes that may only be possible in SAS - i.e. SAS functions & Formats.