[atom_arranger]

There are projects out there that do this.

Possibly relevant: https://yale-lily.github.io/spider

I briefly worked on a startup to commercialize this tech, but we decided it wasn't accurate enough to be useful. It was very cool when it actually worked. If you can only produce what you want half the time on simple queries, that doesn't seem very useful to me though.

[weepa]

Can you elaborate on what kind of use cases you were trying to tackle using NL2SQL in that startup? Who was the target audience/persona?

[atom_arranger]

Any company that has a lot of data in an SQL system that they want to make sense of. The idea would be that business intelligence people, analysts, the CEO, anyone who needed answers could ask a question in plain english and hopefully get a response.

The success rate was just not good enough, even for relatively simple queries. You'd probably need to adjust the query 90% of the time, and the other 10% you couldn't even really trust that the answer was correct.