ObjectNotExecutableError when running Pandasql query in Google Colab

Question

I have a pandas dataframe called df.

Doing a standard SQL query using pandasql. However, it gives me the following error:

ObjectNotExecutableError: Not an executable object: 'SELECT * FROM df'

from pandasql import sqldf
q1 = """SELECT * FROM df"""
sqldf(q1, globals())

Answer 1

in my case pip install SQLAlchemy==1.4.46 and restart kernel solved the issue.