Steve,

>Any solutions, other than renaming all my fields?

Renaming them in the SELECT would be the easiest place to make the change:

select ... TheLongFieldName as ShortName ...

this will also allow you to control the field names instead of having truncated field names.