How To Prevent Pandas Dataframe From Adding Double Quotes Around #tmp When Using Sqlalchemy And Sybase?

I have reduced the issue to pandas to_sql adding double quotes around #tmp when dealing with sybase using sqlalchemy as the pooling framework. Code : def get_data_with_tmp():

Solution 1:

This bug has been fixed in the external sybase dialect

https://github.com/gordthompson/sqlalchemy-sybase

specifically

https://github.com/gordthompson/sqlalchemy-sybase/releases/tag/1.0.1