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.