Currently, on the output tab of a recipe, you can see all the columns that will be output, and there are even "grab bars" (highlighted in yellow) that look like you should be able to reorder them, but the tool won't allow you to do so.
Requires creating a prep step just to reorder columns in many cases.
The extra prep step means another dataset that wouldn't otherwise exist.
As with the wasted storage, this requires reprocessing the data, which typically doubles the processing time.
Allow users to use the "grab bars" to reorder columns in the output step. This would then alter the order the columns are selected in the SQL.