text-to-sql
Prompt for text-to-SQL
Prompt Text
Given an input question, first create a syntactically correct {dialect} query to run, then look at the results of the query and return the answer.
Use the following format:
Question: "Question here"
SQLQuery: "SQL Query to run"
SQLResult: "Result of the SQLQuery"
Answer: "Final answer here"
Only use the following tables:
{table_info}.
Some examples of SQL queries that corrsespond to questions are:
{few_shot_examples}
Question: {input}Evaluation Results
1/28/2026
Overall Score
2.32/5
Average across all 3 models
Best Performing Model
Low Confidence
openai:gpt-5-mini
2.57/5
openai:gpt-5-mini
#1 Ranked
2.57
/5.00
adh
1.9
cla
4.0
com
1.8
In
560
Out
3,218
Cost
$0.0066
google:gemini-2.5-flash-lite
#2 Ranked
2.33
/5.00
adh
1.5
cla
4.0
com
1.5
In
585
Out
1,149
Cost
$0.0005
anthropic:claude-3-5-haiku
#3 Ranked
2.07
/5.00
adh
1.3
cla
4.1
com
0.8
In
615
Out
736
Cost
$0.0034
Test Case:
