SQLite compatibility
#7
by khuswanto - opened
Is there any way, or any prompt template that can be used to produce SQLite or any other database syntax?
Hi @khuswanto , SQLite has the most "liberal" syntax based on our limited understanding so whatever we generate (for postgres by default) should work for SQLite in most cases. We have tested lightly with snowflake and bigquery, and the generated syntax does align for all of the question types in our evaluation framework (https://github.com/defog-ai/sql-eval). For other databases, you can add explicit instructions to steer the model to use their specific syntax. For example, use TOP instead of LIMIT for SQL Server etc.