This may not have a good answer but maybe?
So I have a number of Access databases that query a SQL Server through ODBC to generate reports. The SQL Server backend is being changed out and I need to translate Access Queries to SQL Server queries of the new backend. I have mappings of all the current SQL Server backend to new backend. Some of the fields in the SQL Server are encrypted and only accessible through Access and as far as I know the person that has the password to decrypt the SQL Server fields is MIA/presumed KIA.
The document I have that lists out all the reports that need to be recreated has the Access field names not the SQL Server field names. Is there a good way to programatically get the SQL Code from Access and save it off as a text file or something I can parse with Python? My thought is if I can do this I could parse it to get the original field names not their aliases. Then I can feed that into my program for outputting the new SQL Server table and fieldnames.