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 |
|---|---|---|---|---|
| 279 | Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation | 2024 | VLDB | 0.00022468369 |
| 5,438 | PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns | 2021 | VLDB | 6.2195845e-05 |
| 7,093 | DICE: Data Discovery by Example | 2021 | VLDB | 5.7056625e-05 |
| 9,020 | Data-Driven Insight Synthesis for Multi-Dimensional Data | 2024 | VLDB | 5.3306775e-05 |
| 9,112 | Towards Enhancing Database Education: Natural Language Generation Meets Query Execution Plans | 2021 | SIGMOD | 5.3218986e-05 |
| 11,013 | Towards Automated Cross-domain Exploratory Data Analysis through Large Language Models | 2025 | VLDB | 5.093636e-05 |
| 11,245 | Relational Query Synthesis ⋈ Decision Tree Learning | 2024 | VLDB | 5.093636e-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 |
|---|---|---|---|---|
| 179 | Constructing an Interactive Natural Language Interface for Relational Databases | 2015 | VLDB | 0.00026838277 |
| 459 | ATHENA: An Ontology-Driven System for Natural Language Querying over Relational Data Stores | 2016 | VLDB | 0.00018101318 |
| 1,192 | Query From Examples: An Iterative, Data-Driven Approach to Query Construction | 2015 | VLDB | 0.00011740132 |
| 1,262 | Discovering Queries based on Example Tuples | 2014 | SIGMOD | 0.00011427456 |
| 1,751 | Sample-Driven Schema Mapping | 2012 | SIGMOD | 9.838446e-05 |
| 2,387 | S4: Top-k Spreadsheet-Style Search for Query Discovery | 2015 | SIGMOD | 8.6482009e-05 |
| 3,444 | REGAL+: Reverse Engineering SPJA Queries | 2018 | VLDB | 7.4094584e-05 |
| 3,677 | Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity | 2019 | VLDB | 7.2076465e-05 |
| 4,644 | Reverse Engineering SPJ-Queries from Examples | 2017 | PODS | 6.5901073e-05 |
| 8,987 | Constructing Expressive Relational Queries with Dual-Specification Synthesis | 2020 | CIDR | 5.3387464e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 5,738 | SpeakQL: Towards Speech-driven Multimodal Querying of Structured Data | 2020 | SIGMOD |
| 2 | 3,677 | Example-Driven Query Intent Discovery: Abductive Reasoning using Semantic Similarity | 2019 | VLDB |
| 3 | 1,922 | QUEST: A Keyword Search System for Relational Data based on Semantic and Machine Learning Techniques | 2013 | VLDB |
| 4 | 9,136 | Sphinteract: Resolving Ambiguities in NL2SQL Through User Interaction | 2025 | VLDB |
| 5 | 4,593 | Demonstration of SpeakQL: Speech-driven Multimodal Querying of Structured Data | 2019 | SIGMOD |
| 6 | 1,444 | CatSQL: Towards Real World Natural Language to SQL Applications | 2023 | VLDB |
| 7 | 5,174 | An In-Depth Benchmarking of Text-to-SQL Systems | 2021 | SIGMOD |
| 8 | 179 | Constructing an Interactive Natural Language Interface for Relational Databases | 2015 | VLDB |
| 9 | 11,543 | VoiceQuerySystem: A Voice-driven Database Querying System Using Natural Language Questions | 2022 | SIGMOD |
| 10 | 8,987 | Constructing Expressive Relational Queries with Dual-Specification Synthesis | 2020 | CIDR |