Some passing the schema with examples and some, if no longer than 2048 tokens, with sql examples, like:
Below are some sample questions and their corresponding SQL queries that might help you answer the user's question:
[QUESTION]What is the number of cars with a greater accelerate than the one with the most horsepower?[/QUESTION]
[SQL]SELECT COUNT(*)
FROM CARS_DATA
WHERE Accelerate >
(SELECT Accelerate
FROM CARS_DATA
ORDER BY Horsepower DESC
LIMIT 1);[/SQL]
#<|ddl|>
The query will run on a database with the following schema:
/*
2 rows from car_makers table:
Id Maker FullName Country
1 amc American Motor Company 1
2 volkswagen Volkswagen 2
*/
Max sequence length: 2048
After filtering the dataset, there are 7665 rows remaining
Prompt:
"""# <|system|>
You are a chatbot tasked with responding to questions about an SQLite database.
Your responses must always consist of valid SQL code, and only that.
If you are unable to generate SQL for a question, respond with 'I do not know'.{sql_example}
# <|ddl|>
The query will run on a database with the following schema:
{ddl}
# <|user|>
{question}
# <|assistant|>
[SQL]"""
Model Details
Model Description
This is the model card of a 🤗 transformers model that has been pushed on the Hub. This model card has been automatically generated.
Developed by: [More Information Needed]
Funded by [optional]: [More Information Needed]
Shared by [optional]: [More Information Needed]
Model type: [More Information Needed]
Language(s) (NLP): [More Information Needed]
License: [More Information Needed]
Finetuned from model [optional]: [More Information Needed]
Model Sources [optional]
Repository: [More Information Needed]
Paper [optional]: [More Information Needed]
Demo [optional]: [More Information Needed]
Uses
Direct Use
[More Information Needed]
Downstream Use [optional]
[More Information Needed]
Out-of-Scope Use
[More Information Needed]
Bias, Risks, and Limitations
[More Information Needed]
Recommendations
Users (both direct and downstream) should be made aware of the risks, biases and limitations of the model. More information needed for further recommendations.
