Views
No views yet
Omni-SQL-32B.Agentar-Scale-SQL framework's "Diverse Synthesis" step, working in parallel with an ICL generator to produce a robust pool of SQL candidates.| Model | Role |
|---|---|
| Agentar-Scale-SQL-Generation-32B | SQL Generator |
| Agentar-Scale-SQL-Selection-32B | SQL Selector |
| Methods | EX (Dev) | EX (Test) | R-VES (%) |
|---|---|---|---|
| Agentar-Scale-SQL (Ours) | 74.90 | 81.67 | 77.00 |
| AskData + GPT-4o | 76.14 | 80.88 | 76.24 |
| LongData-SQL | 74.32 | 77.53 | 71.89 |
| CHASE-SQL + Gemini | 74.90 | 76.02 | 69.94 |
| JoyDataAgent-SQL | 74.25 | 75.74 | 70.16 |
| TCDataAgent-SQL | 74.12 | 75.74 | - |
| Contextual-SQL | 73.50 | 75.63 | 70.02 |
| XiYan-SQL | 73.34 | 75.63 | 71.41 |
1PROMPT_TEMPLATE = """Task Overview:
2You are a data science expert. Below, you are provided with a database schema and a natural language question. Your task is to understand the schema and generate a valid SQL query to answer the question.
3
4Database Engine:
5{{ dialect }}
6
7Database Schema:
8{{ db_schemas }}
9This schema describes the database's structure, including tables, columns, primary keys, foreign keys, and any relevant relationships or constraints.
10{% if matched_contents %}
11Matched contents:
12{{ matched_contents }}
13Matched contents presents values related to the question, together with their source table and column, for your reference in SQL generation.
14{% endif %}
15Question:
16{%- if hint %}
17{{ hint }}
18{{ question }}
19{%- else %}
20{{ question }}
21{%- endif %}
22
23Instructions:
24- If Matched contents is provided, you can use it as reference when generating the SQL query.
25- Make sure you only output the information that is asked in the question. If the question asks for a specific column, make sure to only include that column in the SELECT clause, nothing more.
26- The generated query should return all of the information asked in the question without any missing or extra information.
27- Before generating the final SQL query, please think through the steps of how to write the query.
28
29Output Format:
30In your answer, please enclose the generated SQL query in a code block:
31```sql
32-- Your SQL query
33```
34
35Take a deep breath and think step by step to find the correct SQL query.
36"""1@misc{wang2025agentarscalesqladvancingtexttosqlorchestrated,
2 title={Agentar-Scale-SQL: Advancing Text-to-SQL through Orchestrated Test-Time Scaling},
3 author={Pengfei Wang and Baolin Sun and Xuemei Dong and Yaxun Dai and Hongwei Yuan and Mengdie Chu and Yingqi Gao and Xiang Qi and Peng Zhang and Ying Yan},
4 year={2025},
5 eprint={2509.24403},
6 archivePrefix={arXiv},
7 primaryClass={cs.CL},
8 url={https://arxiv.org/abs/2509.24403},
9}