Currently (as of 8.7) the SQL generator creates select statements as Select * instead of the more correct Select <field name list>. This will also have the advantage of allowing files to add fields without the need to recompile all programs.
Yeah, I think Eamonn was upset that his first idea was closed off..kudos to him for opening it again...
SQL Selects list out fields to be read
SELECT * - IBM DB2 - IBM DB2 - Toad World