Another idea that might help you and this one may seem like I am doing mushrooms but I have used it for generating Prolog code, specifically web pages.
The problem may be that generative AI has a harder time understanding SQL because it is a declarative language and much of the success with programming languages with generative AI comes from large training sets on a few imperative programming languages like JavaScript, Python, Java, etc. But generative AI which is based on transformers and transformers were initially created to translate from IIRC English to German are great at translating to/from the well trained programming languages. So if instead asking for SQL at the start instead ask for a Python or other such well trained programming language for the code to solve the problem then have the generative AI translate the Python to SQL and see if that works. I don’t plan to try this but since you seem to enjoy this, be my guest. Also if you do this, please give feedback as I would definitely like to know what you discover. 