example:
Initial Prompt:
"Here is the schema for a database:
CREATE TABLE persons (
id INTEGER PRIMARY KEY AUTOINCREMENT,
first_name TEXT NOT NULL,
last_name TEXT NOT NULL,
age INTEGER NOT NULL
);
CREATE TABLE Y(blah blah blah)
I'll pose a question and I want you to:
Respond with JSON which has two fields, Query and Error.
Query: A SQL query to get the required information
Error: An error message to pass back to the user if it's not possible.
Question: Show me all the people who are over 40.
"
Response from prompt: {Query: "Select years_old from persons where age > 40", Error:""}
Now, in your "agent":
Get that response, run it against your db, get the error message. Go back to the GPT-4 api with the initial prompt and response, and add "this doesn't work and gives the following error message. Correct your response and responde in JSON again."
And so on.