django-sql-explorer icon indicating copy to clipboard operation
django-sql-explorer copied to clipboard

Remind AI Assistant to quote SQLite tables

Open chrisclark opened this issue 1 year ago • 0 comments

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).

chrisclark avatar Jul 05 '24 20:07 chrisclark