[croes]

I doubt it's useful for complex queries or databases without proper relation info in the database schemes.

So it's limited to rather simple queries for users without SQL knowledge. But I doubt they should have direct access to the database tables.

[lofties]

Usually what you do with these type of LLMs is pass on most if not all of the schema in your query.

And you’re right in that the end user wouldn’t have access to the schema, although perhaps via prompt injection they could.

[croes]

The problem is there are programs where the schemes don't show the necessary links between the programs data tables like foreign keys for instance.

[thecalebf]

Yes it is designed for users without SQL knowledge, however, it can still perform fairly well with questions on the difficult side (for non technical users) with queries having multiple joins, aggregations, ratios, and subqueries.

Next step is fine tuning and leveraging larger models that can handle very complex questions, reasoning, and data schemas since this is only a 7B.