News for hackers. Stuff that matters.
Re:An open source DuckDB text to SQL LLM by nerpderp82 on Thursday January 25, 2024 @04:25PM (#39135537)
I believe that is what they are saying.

I have found LLMs to be extremely helpful in mapping between schemas as well as helping me formulate queries where, because of decay, data in tables and column names, etc don't map to what you think they would.

You need to provide as much context as you can to the LLM. So full schema definitions, and histographic summarization and samples from the tables themselves.

Re:An open source DuckDB text to SQL LLM by swingingFlyFish on Friday January 26, 2024 @05:00PM (#39149182)
I hear what you're saying, and actually agree that - unfortunately - is the current state of LLMs today. But I think OP still has a point, and I'd argue as well that that is the aim of GAI, to be able to take a simple question, understand and produce the desired results.

As it stands, and as you mentioned, the current generation of LLMS seem a long way from there. Thus the need for prompt engineers. It'll be nice to see how long they take to crack this problem.