Duoquest: A Dual-Specification System for Expressive SQL Queries
Summary: Proposes Duoquest, a dual-specification system that combines natural-language queries with optional PBE-style table sketches to express SQL without full schema knowledge. Uses guided partial query enumeration to explore the space efficiently, delivering a 62.5% absolute accuracy gain over a leading NLI and more than 2x Spider top-1 accuracy vs NLI/PBE. (summarized by gpt-5-nano on Feb 09 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Christopher Baik (University of Michigan)
- 2. Zhongjun Jin (University of Michigan)
- 3. Michael Cafarella (University of Michigan)
- 4. H. V. Jagadish (University of Michigan)
BibTeX Citation
@inproceedings{baik_sigmod20,
title = {{Duoquest: A Dual-Specification System for Expressive SQL Queries}},
author = {Baik, Christopher and Jin, Zhongjun and Cafarella, Michael and Jagadish, H. V.},
series = {{SIGMOD} '20},
booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
publisher = {Association for Computing Machinery},
doi = {10.1145/3318464.3389776},
url = {https://dl.acm.org/doi/10.1145/3318464.3389776},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 7 of 7 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 174 | Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation | 2024 | VLDB | 0.00026790979 |
| 5,520 | PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns | 2021 | VLDB | 6.0964774e-05 |
| 7,218 | DICE: Data Discovery by Example | 2021 | VLDB | 5.5832755e-05 |
| 9,173 | Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans | 2021 | SIGMOD | 5.2135302e-05 |
| 9,192 | Data-Driven Insight Synthesis for Multi-Dimensional Data | 2024 | VLDB | 5.2110714e-05 |
| 11,379 | Towards Automated Cross-domain Exploratory Data Analysis through Large Language Models | 2025 | VLDB | 4.9793485e-05 |
| 11,578 | Relational Query Synthesis ⋈ Decision Tree Learning | 2024 | VLDB | 4.9793485e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 10 of 10 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 180 | Constructing an Interactive Natural Language Interface for Relational Databases | 2015 | VLDB | 0.0002654471 |
| 439 | ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores | 2016 | VLDB | 0.00018251249 |
| 1,211 | Query From Examples: An Iterative, Data-Driven Approach to Query Construction | 2015 | VLDB | 0.00011524858 |
| 1,272 | Discovering Queries based on Example Tuples | 2014 | SIGMOD | 0.00011248674 |
| 1,776 | Sample-Driven Schema Mapping | 2012 | SIGMOD | 9.6674087e-05 |
| 2,412 | S4: Top-k Spreadsheet-Style Search for Query Discovery | 2015 | SIGMOD | 8.5101348e-05 |
| 3,461 | REGAL+: Reverse Engineering SPJA Queries | 2018 | VLDB | 7.2839794e-05 |
| 3,504 | Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity | 2019 | VLDB | 7.2516839e-05 |
| 4,660 | Reverse Engineering SPJ-Queries from Examples | 2017 | PODS | 6.4822086e-05 |
| 9,143 | Constructing Expressive Relational Queries with Dual-Specification Synthesis | 2020 | CIDR | 5.2203147e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,862 | SpeakQL: Towards Speech-driven Multimodal Querying of Structured Data | 2020 | SIGMOD |
| 2 | 1,921 | QUEST: A Keyword Search System for Relational Data based on Semantic and Machine Learning Techniques | 2013 | VLDB |
| 3 | 3,504 | Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity | 2019 | VLDB |
| 4 | 9,304 | Sphinteract: Resolving Ambiguities in NL2SQL Through User Interaction | 2025 | VLDB |
| 5 | 4,694 | Demonstration of SpeakQL: Speech-driven Multimodal Querying of Structured Data | 2019 | SIGMOD |
| 6 | 1,356 | CatSQL: Towards Real World Natural Language to SQL Applications | 2023 | VLDB |
| 7 | 5,155 | An In-Depth Benchmarking of Text-to-SQL Systems | 2021 | SIGMOD |
| 8 | 180 | Constructing an Interactive Natural Language Interface for Relational Databases | 2015 | VLDB |
| 9 | 11,852 | VoiceQuerySystem: A Voice-driven Database Querying System Using Natural Language Questions | 2022 | SIGMOD |
| 10 | 9,143 | Constructing Expressive Relational Queries with Dual-Specification Synthesis | 2020 | CIDR |