It ain’t about generating perfect queries, its about getting insights about data.
That’s a great way to put it.
With LLM context is really important and especially for critical things like database queries. Passing only the relevant info and cutting the fluff out is the key, but executing SQL queries in itself is that problem for the analyser.
So LLM is just solving that step but for writing the actual query from the natural language.