Request for Help: Code Generative AI vs Data Generative AI

I have a large warehouse database that contains over 1k tables. I want to be able to use AI to generate SQL queries, SProcs and functions based on text prompt like we do with Chat GPT.
I could use Chat GPT but there are so many limitations not in the way that I get answers but in the amount of data (tokens) that I can provide and receive before the AI loses the context of my database tables and schema. …

artificial chat chat gpt code data database functions generative gpt prompt sql sql queries tables text warehouse