search

yhat / pandasql

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

sqldf stopped working with sqlalchemy 2.0.0 #99

Open Simgiov opened 1 year ago

Simgiov commented 1 year ago

sqldf does no longer work since the release of sqlalchemy 2.0.0.

I just installed pandasql on my notebook, the python script that yesterday worked on my desktop doesn't work here. I noticed 12 hours ago a new version of sqlalchemy released (2.0.0)

I did a pip uninstall sqlalchemy and then installed the old 1.4.46 release, the script then worked as expected.

minikill commented 1 year ago

Hi there. We faced the same issue. You can use my fork while the PR isn't merged 😀

hrshdhgd commented 1 year ago

If you want to use SQLAlchemy v2.x, I think merging my PR will resolve this and 2 other issues.

wudstrand commented 1 year ago

+1

zillionare commented 5 months ago

so when could the merge be released?

hrshdhgd commented 5 months ago

I just forked it under my repo and released pansql https://github.com/hrshdhgd/pansql