I can imagine two solutions:

1) Read from the SQL, from there, the name of the variables are "decomposed' and you can shorten it.

2) Use Python, i have written a package that reads the SQL EPW and renames common variables, and also Python and Pandas do not have issues with the extension of the names. Take a look at my package, specifically to the function read_sql, https://github.com/AltamarMx/iertools/blob/main/iertools/read.py