3 ms·
Ah, I see, could you try now? The quota should be fixed, my bad there, had a bug. Now about the query, DuckDB works in the following way, the query you sent sh
by tarasyarema 3y ago
Ah, I see, could you try now? The quota should be fixed, my bad there, had a bug.
Now about the query, DuckDB works in the following way, the query you sent should be written like
> SELECT * from <table> where "Status" = 'Complete';
Now this is because the `"` is used for the table and column names, and the `'` is used for raw string. See more here https://duckdb.org/docs/sql/introduction#querying-a-table https://duckdb.org/docs/sql/introduction#querying-a-table which might be a bit different from other SQL database engines.
And finally, regarding the autocomplete, it indeeds tries to autocomplete in a too verbose way, which is something I'll try to improve.
Thanks for reaching out, and hopefully this can help you try it out!
- andybak 3y agoYes. Obvious in hindsight but - this underlines my point that a few examples would make life a lot easier for people casually trying it out.
- tarasyarema 3y agoTotally, In fact I think it would be nice to have a sort of interactive example based on one of your sheets, definitely! Thanks for the feedback.