I would like to see query builders have an option to perform a SELECT * statement. For instance, I don't believe the following is possible using a query builder:
PROC SQL;
CREATE TABLE WORK.TMP AS
SELECT t1.*, MAX(t1.Age) AS Max_Age
FROM SASHELP.CLASS t1
GROUP BY t1.Sex;
QUIT;
Currently when you right click on a table in the left hand pane and choose "Select All Columns" it inserts each column separately and ends up building the following code:
PROC SQL;
CREATE TABLE WORK.TMP AS
SELECT t1.Name,
t1.Sex,
t1.Age,
t1.Height,
t1.Weight,
/* Max_Age */
(MAX(t1.Age)) AS Max_Age
FROM SASHELP.CLASS t1
GROUP BY t1.Sex;
QUIT;
I often have very long process flows with several query builders that are bringing all columns forward with them. If I add a new column to a table at the beginning of the flow, I then have to open each subsequent query builder and add the column. Having a special "select all" row in the select data tab of the query builder would alleviate this issue.