datasloth icon indicating copy to clipboard operation
datasloth copied to clipboard

Consistent Issue with executing queries

Open isConic opened this issue 1 year ago • 0 comments

what I'm trying

sloth.query("Number of men over 30 on board the titanic", show_query= True)

The error

ObjectNotExecutableError: Not an executable object: "SELECT COUNT(*) AS men_over_30\nFROM real_data\nWHERE Sex = 'male' AND Age > 30"

What sloth.show_last_query() gets me:

SELECT COUNT(*) AS men_over_30
FROM real_data
WHERE Sex = 'male' AND Age > 30

pandas versioning:

pandas==1.5.3
pandas-datareader==0.10.0
pandas-gbq==0.17.9
pandasql==0.7.3

isConic avatar May 30 '23 19:05 isConic