Ask HN: How do you make GPT generate SQL across multiple tables?

2 points

a year ago

I've been experimenting with prompt engineering for GPT-3.5, and found it struggles a lot when generating SQL over multi-table schemas (JOINs, FK logic, etc).

So I built a lightweight framework called USPL to fix that — no fine-tuning, no plugins, just a clean JSON schema format that GPT can reason over.

Would love to hear how others approach this problem. Have you found good ways to guide LLMs for structured query generation?

GitHub: https://github.com/ZeppelinTsai/USPL Blog: https://dev.to/donkey_d_8fe161b59fbb5225/why-i-built-uspl-helping-gpt-understand-multi-table-sql-1pln