SQUARES: A SQL Synthesizer Using Query Reverse Engineering
Summary: SQUARES tackles Query Reverse Engineering: synthesizing SQL from a database and desired output table, enabling nonprogrammer analysts to specify transformations by examples. It also generates equivalent table-manipulation programs in R. (summarized by gpt-5.6-luna on Jul 24 2026)
Incoming Non-self Citations Over Time
Authors
- 1. Pedro Orvalho (Institute for Systems and Computer Engineering, Research and Development)
- 2. Miguel Terra-Neves (OutSystems)
- 3. Miguel Ventura (OutSystems)
- 4. Ruben Martins (Carnegie Mellon University)
- 5. Vasco Manquinho (Institute for Systems and Computer Engineering, Research and Development; Instituto Superior Tecnico)
BibTeX Citation
@article{orvalho_vldb20,
title = {{SQUARES: A SQL Synthesizer Using Query Reverse Engineering}},
author = {Orvalho, Pedro and Terra-Neves, Miguel and Ventura, Miguel and Martins, Ruben and Manquinho, Vasco},
journal = {PVLDB},
series = {{VLDB} '20},
volume = {13},
number = {12},
pages = {2853--2856},
doi = {10.14778/3415478.3415492},
url = {https://doi.org/10.14778/3415478.3415492},
year = {2020}
}Incoming Citations (Sorted by Pagerank)
Showing 3 of 3 citing papers.
| Rank | Citing Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 4,990 | Explaining Dataset Changes for Semantic Data Versioning with Explain-Da-V | 2023 | VLDB | 6.4105738e-05 |
| 5,438 | PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns | 2021 | VLDB | 6.2195845e-05 |
| 9,105 | Shedding Light on Opaque Application Queries | 2021 | SIGMOD | 5.3239455e-05 |
Previous
Page 1 / 1
Next
Outgoing Citations (Sorted by Pagerank)
Showing 5 of 5 cited papers.
Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.
| Rank | Cited Paper | Year | Venue | Pagerank |
|---|---|---|---|---|
| 1,313 | Reverse Engineering Complex Join Queries | 2013 | SIGMOD | 0.00011186284 |
| 2,631 | FastQRE: Fast Query Reverse Engineering | 2018 | SIGMOD | 8.3231158e-05 |
| 3,300 | Reverse Engineering Aggregation Queries | 2017 | VLDB | 7.5412976e-05 |
| 4,733 | Interactive Query Synthesis from Input-Output Examples | 2017 | SIGMOD | 6.5335361e-05 |
| 7,552 | Trinity: An Extensible Synthesis Framework for Data Science | 2019 | VLDB | 5.6005243e-05 |
Previous
Page 1 / 1
Next
Semantically Similar Papers
| # | Overall Rank | Paper | Year | Venue |
|---|---|---|---|---|
| 1 | 8,834 | Qr-Hint: Actionable Hints Towards Correcting Wrong SQL Queries | 2024 | SIGMOD |
| 2 | 11,489 | Demo of QueryBooster: Supporting Middleware-Based SQL Query Rewriting as a Service | 2023 | VLDB |
| 3 | 4,671 | PreQR: Pre-training Representation for SQL Understanding | 2022 | SIGMOD |
| 4 | 3,444 | REGAL+: Reverse Engineering SPJA Queries | 2018 | VLDB |
| 5 | 4,196 | Automatic Example Queries for Ad Hoc Databases | 2011 | SIGMOD |
| 6 | 5,438 | PATSQL: Efficient Synthesis of SQL Queries from Example Tables with Quick Inference of Projected Columns | 2021 | VLDB |
| 7 | 12,088 | Synthesizing Data Programs | 2015 | CIDR |
| 8 | 1,192 | Query From Examples: An Iterative, Data-Driven Approach to Query Construction | 2015 | VLDB |
| 9 | 4,733 | Interactive Query Synthesis from Input-Output Examples | 2017 | SIGMOD |
| 10 | 2,631 | FastQRE: Fast Query Reverse Engineering | 2018 | SIGMOD |