@Tess
Thank you for bumping in. The method I am using is generating the SQL for a query using Retool AI. I understand the issue of wrong syntax. But if we craft the prompt with more context by providing the table schema and more details about the kind of data we have, we can always get the correct SQL 99% of the time.
The real cool part comes in when we combine OpenAI's Assistants API with Retool. Right now I am running that feature outside the Retool AI as Retool AI is still not supporting it. But I have requested Retool to give us that end-point as well. We can do some amazing stuff with Assistants API as we can talk to code-interpreter and Function Calling. This will unlock many things for us.