search

explorerhq / sql-explorer

SQL reporting that Just Works. Fast, simple, and confusion-free. Write and share queries in a delightful SQL editor, with AI assistance.
https://www.sqlexplorer.io
Other
2.74k stars 363 forks source link

Remind AI Assistant to quote SQLite tables #641

Open chrisclark opened 2 months ago

chrisclark commented 2 months ago

The AI assistant fairly frequently 'forgets' to put double quotes around table names a and fields when generating SQL to query SQLite files.

Alternatively (or perhaps additionally), we could improve the AI flow a bit to try and get it to execute the SQL it generates, and debug itself (this does prove effective -- simply re-running the prompt with the error included will generally fix the problem).