> So I dont know what is the answer to the question "how do people do things they don't know how to do" ?
The statue quo had been to learn SQL or ask a human you trust to check their own work, which hopefully you can reuse.
Now it's ask AIs that are intentionally a bit random, and less likely to (or incapable of) check(ing) their work. Perhaps without seeing the SQL at all, requiring to trust it for every interaction. And in a culture that moves so fast that there is no checking by any(one|thing).
If you think a language model can't check their work, then you are using the tools wrong. Plain and simple.
Modern models are quite capable at surfacing and validating their assumptions and checking correctness of solutions.
Oversight helps you build confidence in the solutions. Is it perfect, no.. but way better then most engineers I also ask to check things.