search

yhat / pandasql

sqldf for pandas
MIT License
1.31k stars 184 forks source link

fix SQLAlchemy doesn't accept raw str anymore #109

Open BuiHoangTu opened 3 months ago

BuiHoangTu commented 3 months ago

Query using postgresql syntax does not work since conn.execute() require sqlalchemy.text instead of str like before.

So i tried wrapping original string by text and it worked.

BuiHoangTu commented 3 months ago

fix #99 ; #102 ; #103

Crowts commented 3 months ago

I had the same issue just yesterday with engine.execute() not working and resolved it the same way.