Hopefully I am not feeding your addiction.
I don’t know if you read research papers but today ran across another one reinforcing that you are on a valid path and that the paper can hopefully point out new avenues for achieving the goal of generating valid SQL and results starting with a natural language query.
The paper is for math problems but since math is just an expression as is SQL, just change out one form of expression for another and it should make sense. There are many such related papers all with similar ideas so don’t consider this one as authoritative.
“Solving Challenging Math Word Problems Using Gpt-4 Code Interpreter With Code-Based Self-Verification” by Aojun Zhoun, Ke Wang, Zimu Lu, Weikang Shi, Sichun Luo, Zipeng Qin, Shaoqing Lu, Anya Jia, Linqi Song, Mingjie Zhan and Hongsheng Li (pdf)