News for hackers. Stuff that matters.
Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by croes on Monday February 05, 2024 @11:21AM (#39262883)
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.

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.

Re:Show HN: Natural-SQL-7B, a strong text-to-SQL model by croes on Monday February 05, 2024 @08:05PM (#39269458)
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.