Is there a way, in an SQL select statement, to refer to a column/field by other than its name?

e.g. in the Order by clause you can use "2,1" to refer to the 2nd & 1st columns.

The problem is that some imported data has huge column names, essentially long questions "What is your favorite color and the air speed velocity ..."
and I'd rather get at the data via something like
Select 1,2,3 From xxx
or
Select Field1,Field2 etc.

I know I can do this using a recordset in VB/VBA, but I'd like to use SQL.

Thanks, DaveBo