from Hacker News

Ask HN: Integrating SQL and LLM what is you experience

by yonisto on 1/22/25, 7:22 AM with 3 comments

I was tasked with building a "native language interface" to our database. After developing it for a month, it seems to me that I hit a wall with the correctness of the resulting SQL. 80-20 would be a good estimate. My feeling is that it something that cannot be used a regular user.

Did you do better and you have tips?

NOTE: I'm not talking about performant queries only about producing a correct result. I would say that only about 50% cannot be better optimized, but I don't care about that.

by lunarcave on 1/22/25, 7:33 AM
Does this [1] look like the thing you're looking for?
We built a basic Re-Act agent that can dynamically inspect the database context and generate the queries iteratively.
Our experience was that it was hard to do single-shot.
Happy to answer any questions.
[1] https://github.com/inferablehq/inferable/tree/main/adapters/...