DBScholar

Back to papers

OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment

Summary: OpenSearch-SQL proposes a modular Text-to-SQL pipeline with a Consistency Alignment module to curb instruction deviations and hallucinations. It uses a SQL-Like intermediate language and dynamic few-shot Query-CoT-SQL to run base LLMs without fine-tuning, achieving top EX and R-VES on BIRD. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
h899244bdd38e9503
Venue
SIGMOD
Year
2025
Pagerank
9.163622e-05
Overall Rank
2,025 | 86.39%
DOI
10.1145/3725331

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@inproceedings{xie_sigmod25,
        title = {{OpenSearch-SQL: Enhancing Text-to-SQL with Dynamic Few-shot and Consistency Alignment}},
        author = {Xie, Xiangjin and Xu, Guangwei and Zhao, Lingyan and Guo, Ruijie},
        series = {{SIGMOD} '25},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3725331},
        url = {https://dl.acm.org/doi/10.1145/3725331},
        year = {2025}
}

Incoming Citations (Sorted by Pagerank)

Showing 14 of 14 citing papers.

Rank Citing Paper Year Venue Pagerank
9,068 ST-Raptor: LLM-Powered Semi-Structured Table Question Answering 2026 SIGMOD 5.2283159e-05
9,217 Text-to-SQL Benchmarks are Broken: An In-Depth Analysis of Annotation Errors 2026 CIDR 5.2056825e-05
10,427 Comparison and Analysis of Value Linking in Text-to-SQL Systems [Experiments & Analysis] 2026 SIGMOD 4.9793485e-05
10,433 DeepEye-SQL: A Software-Engineering-Inspired Text-to-SQL Framework 2026 SIGMOD 4.9793485e-05
10,545 Are Your LLM-based Text-to-SQL Models Secure? Exploring SQL Injection via Backdoor Attacks 2026 SIGMOD 4.9793485e-05
10,594 Reliable Answers for Recurring Questions: Boosting Text-to-SQL Accuracy with Template Constrained Decoding 2026 SIGMOD 4.9793485e-05
10,621 Beluga: A CXL-Based Memory Architecture for Scalable and Efficient LLM KVCache Management 2026 SIGMOD 4.9793485e-05
10,632 DIVER: A Robust Text-to-SQL System with Dynamic Interactive Value Linking and Evidence Reasoning 2026 SIGMOD 4.9793485e-05
10,695 NL2SQLBench: A Modular Benchmarking Framework for LLM-Enabled NL2SQL Solutions 2026 VLDB 4.9793485e-05
10,738 OpenSQL: Data-Efficient Text-to-SQL for Open-Source LLMs via Synthesized Intermediate Supervision 2026 VLDB 4.9793485e-05
10,766 A Comparative Evaluation of Schema Subsetting for LLM-based NL-to-SQL over Large-Schema Databases 2026 VLDB 4.9793485e-05
10,780 SafeQL: Search-based Refinement for Safe and Efficient LLM-based Text-to-SQL 2026 VLDB 4.9793485e-05
10,940 Bridging NL2SQL for CAN Signal Analytics at NIO: From Externalized Schemas to CTE Pipelines 2026 VLDB 4.9793485e-05
11,071 Pervasive Annotation Errors Break Text-to-SQL Benchmarks and Leaderboards 2026 VLDB 4.9793485e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 4 of 4 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank Cited Paper Year Venue Pagerank
38 DISCOVER: Keyword Search in Relational Databases 2002 VLDB 0.00047394041
174 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB 0.00026790979
217 Efficient IR-Style Keyword Search over Relational Databases 2003 VLDB 0.00024465994
533 CodeS: Towards Building Open-source Language Models for Text-to-SQL 2024 SIGMOD 0.00016826571
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 1,777 OmniSQL: Synthesizing High-quality Text-to-SQL Data at Scale 2025 VLDB
2 10,958 SpatialSQL: A Multi-Agent System for Interactive and Observable Spatial Text-to-SQL 2026 VLDB
3 3,489 Combining Small Language Models and Large Language Models for Zero-Shot NL2SQL 2024 VLDB
4 3,743 Logical and Physical Optimizations for SQL Query Execution over Large Language Models 2025 SIGMOD
5 533 CodeS: Towards Building Open-source Language Models for Text-to-SQL 2024 SIGMOD
6 7,012 Reliable Text-to-SQL with Adaptive Abstention 2025 SIGMOD
7 9,222 SQL-Factory: A Multi-Agent Framework for High-Quality and Large-Scale SQL Generation 2026 VLDB
8 174 Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation 2024 VLDB
9 10,695 NL2SQLBench: A Modular Benchmarking Framework for LLM-Enabled NL2SQL Solutions 2026 VLDB
10 10,738 OpenSQL: Data-Efficient Text-to-SQL for Open-Source LLMs via Synthesized Intermediate Supervision 2026 VLDB