Re:Show HN: Natural Language to SQL "Text-to-SQL" API
by aazo11 on Wednesday February 14, 2024 @02:34PM
(#39374109)
For large databases, LLMs do not perform well if you pass the entire schema (either run into context window issues or confuse the LLM with too much info). There is a schema linking step that identifies the relevant schema and only passes that. The schema linking is also done in the fine-tuning process.
[ Parent
| on HN ]
Re:Show HN: Natural Language to SQL "Text-to-SQL" API
by deely3 on Wednesday February 14, 2024 @04:05PM
(#39375339)
Good, but.. What do you mean by complex SQL? How complex?
Re:Show HN: Natural Language to SQL "Text-to-SQL" API
by aazo11 on Wednesday February 14, 2024 @04:26PM
(#39375654)
The largest we have successfully deployed is on the OSQuery schema https://osquery.io/ which is 277 tables and lots of business context (malwares, vulnerabilities, Windows registry keys, etc).