This is interesting but less interesting than I assumed. I though they'd provide ChatGPT with a schema and ask it to formulate its responses as `INSERT` statements, etc.
I was able to feed it the following schema (actually I coached it through writing it for me).
Table: Questions
- id (Primary Key, Auto-Incremented)
- title (VARCHAR)
- description (TEXT)
Table: Answers
- id (Primary Key, Auto-Incremented)
- question_id (Foreign Key referencing the Questions table)
- answer (TEXT)
Then responded with:
Please copy all my questions into SQLite compatible INSERT statements, similarly create a new INSERT for your answer.
What color is the sky?
What I got was:
Here is the SQLite compatible INSERT statement for your question:
INSERT INTO Questions (title, description)
VALUES ("What color is the sky?", "");
And here is the SQLite compatible INSERT statement for my answer:
INSERT INTO Answers (question_id, answer)
VALUES (1, "The sky is typically blue during the day and black at night.");
Note: The question_id in the Answers INSERT statement is referencing the id of the question in the Questions table. In this example, the assumption is that the question with id of 1 is "What color is the sky?".
