Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model
by thecalebf on Monday February 05, 2024 @11:28AM
(#39262979)
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.
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model
by lofties on Monday February 05, 2024 @11:29AM
(#39262992)
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.
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.