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.<p>Did you do better and you have tips?<p>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.
Does this [1] look like the thing you're looking for?<p>We built a basic Re-Act agent that can dynamically inspect the database context and generate the queries iteratively.<p>Our experience was that it was hard to do single-shot.<p>Happy to answer any questions.<p>[1] <a href="https://github.com/inferablehq/inferable/tree/main/adapters/pgsql-adapter">https://github.com/inferablehq/inferable/tree/main/adapters/...</a>