select column as "a_very_very_long_field_name"
from table;

a_very_very_long_fi
--------------------

1.

2.

...