Yes, it's text-to-sql. I would just dump your entity relationships into the prompt and ask for the SQL for some example questions. Then, I'd take those and correct the SQL so that it works -- either asking the LLM to correct bugs you see or just doing it by hand. Then I'd put those input-output examples into the prompt and try it on new things and rinse & repeat.
o1-preview will do best, but once you have a good prompt that works well, I would try that out on 4-o and smaller models
Yes, it's text-to-sql. I would just dump your entity relationships into the prompt and ask for the SQL for some example questions. Then, I'd take those and correct the SQL so that it works -- either asking the LLM to correct bugs you see or just doing it by hand. Then I'd put those input-output examples into the prompt and try it on new things and rinse & repeat.
o1-previewwill do best, but once you have a good prompt that works well, I would try that out on 4-o and smaller modelsAwesome! This really helps. I started going down a rabbit hole of text-to-sql too :)
Cool! Happy to help. I'd love to hear how you get on.