Constructing Expressive Relational Queries with Dual-Specification Synthesis
Summary: Proposes dual-specification synthesis: pair an NLQ with an optional PBE-style table sketch so users can express varying schema/intent knowledge and disambiguate NL queries. Duoqest uses guided partial-query enumeration to efficiently synthesize SQL, beating SOTA on Spider. (summarized by gpt-5-mini 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_cidr20,
address = {Amsterdam, Netherlands},
series = {{CIDR} '20},
title = {{Constructing Expressive Relational Queries with Dual-Specification Synthesis}},
booktitle = {Proceedings of the {Conference} on {Innovative} {Data} {Systems} {Research}},
author = {Baik, Christopher and Jin, Zhongjun and Cafarella, Michael and Jagadish, H. V.},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 2 of 2 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 2,048 | Duoquest: A Dual-Specification System for Expressive SQL Queries | 2020 | SIGMOD | 9.2560185e-05 |
| 5,078 | State of the Art and Open Challenges in Natural Language Interfaces to Data | 2020 | SIGMOD | 6.3728705e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 6 of 6 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,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 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 6,239 | Towards a Unified Visual Database Access | 1993 | SIGMOD |
| 2 | 1,444 | CatSQL: Towards Real World Natural Language to SQL Applications | 2023 | VLDB |
| 3 | 6,936 | Reliable Text-to-SQL with Adaptive Abstention | 2025 | SIGMOD |
| 4 | 4,944 | Hybrid Querying Over Relational Databases and Large Language Models | 2025 | CIDR |
| 5 | 9,870 | Natural Language to SQL: State of the Art and Open Problems | 2025 | VLDB |
| 6 | 11,748 | Toward Pure Natural Language Interaction with Databases | 2020 | CIDR |
| 7 | 13,172 | DYNAMIC QUERY INTERPRETATION IN RELATIONAL DATABASES (Extended abstract) | 1987 | PODS |
| 8 | 5,174 | An In-Depth Benchmarking of Text-to-SQL Systems | 2021 | SIGMOD |
| 9 | 179 | Constructing an Interactive Natural Language Interface for Relational Databases | 2015 | VLDB |
| 10 | 2,048 | Duoquest: A Dual-Specification System for Expressive SQL Queries | 2020 | SIGMOD |