28 ms·
Human to SQL Translator
- meghan_rain 4y agoNote that this entire "open source" project is basically just a wrapper around this closed source third-party LLM prompt: > Translate this natural language query into SQL:\n\n"${query}"\n\n${tableSchema ? `Use this table schema:\n\n${tableSchema}\n\n` : ''}SQL Query: https://github.com/whoiskatrin/sql-translator/blob/main/src/translateToSQL.js#L4 https://github.com/whoiskatrin/sql-translator/blob/main/src/...
- Stephen_0xFF 4y agoI’m going to make a search site, but I’ll just call google under the hood. Host it on GitHub and call it open source.
- 8n4vidtmkvmk 4y agoIt's failing. > list the oldest person in each household, their full name and age and how many people are in the household Maybe I didn't express that nicely, but it's output is: > select max(age) as age, full_name, count(*) as num_people from household group by household; The full_name won't necessarily be for the oldest person (or it'll fail because it's not in the group by). That's the whole tricky part.
- ihucos 4y agoHa, sorry for the spam. I did something similar: https://datandy.com/ https://datandy.com/