4 ms·
This is pretty simple in any foundation model, provide a well commented schema and ask for the query
by cloudking 1y ago
This is pretty simple in any foundation model, provide a well commented schema and ask for the query
- tibbar 1y agoStep 1: Your schema has thousands of tables and there aren't many comments. Step 2...
- fsndz 1y agothe smolagents library is also pretty nice to do the scaffolding around the model. Text to sql seems simple in demos, but to make it work in real life complex cases is very hard: https://medium.com/thoughts-on-machine-learning/build-a-text-to-sql-agent-using-the-smolagents-library-c9e7f159c6cb https://medium.com/thoughts-on-machine-learning/build-a-text...
- quantadev 1y agoI agree. There's really no magic to it any more. The table create DDL commands are a very precise description of the tables, so almost nothing more is ever needed. You can just describe in detail what query you need, and any decent LLM can do it just fine.
- galenmarchetti 1y agothere’s two kinds of people using AI to generate SQL…those who say it’s already solved and those who say it’ll be impossible to ever solve
- cloudking 1y agoYep, probably why I got upvoted then downvoted. I've been using LLMs to write SQL queries for 2 years.