Test Data Generation for Complex SQL Queries

Summary: Novel architecture and techniques for generating test data for complex SQL (multi-block, deep nesting, advanced constructs), targeting validation of analytics, application, and text-to-SQL queries. Outperforms prior generators and improves non-equivalence detection. (summarized by gpt-5-mini on Feb 11 2026)

Paper ID: h0a591556b6460c36
Venue: SIGMOD
Year: 2026
Pagerank: 5.4772833e-05
Overall Rank: 7,638 | 48.65%
DOI: 10.1145/3769832

Incoming Non-self Citations Over Time

Authors

1. Sunanda Somwase (AMD; Indian Institute of Technology Mumbai)
2. Parismita Das (Indian Institute of Technology Mumbai; Morgan Stanley)
3. S. Sudarshan (Indian Institute of Technology Mumbai)

BibTeX Citation

@inproceedings{somwase_sigmod26,
        title = {{Test Data Generation for Complex SQL Queries}},
        author = {Somwase, Sunanda and Das, Parismita and Sudarshan, S.},
        series = {{SIGMOD} '26},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/3769832},
        url = {https://dl.acm.org/doi/10.1145/3769832},
        year = {2026}
}

Incoming Citations (Sorted by Pagerank)

Showing 1 of 1 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
10,893	Developing and Benchmarking Verification Algorithms to Improve Text-to-SQL Generation	2026	VLDB	4.9793485e-05

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
1,378	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00010864448
1,680	Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries	2018	VLDB	9.9031411e-05
2,961	Proving Query Equivalence Using Linear Integer Arithmetic	2023	SIGMOD	7.8068219e-05
6,859	Efficient Regression Tests for Database Applications	2005	CIDR	5.6621228e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	1,602	Simple and Realistic Data Generation	2006	VLDB
2	1,928	Detecting Logic Bugs of Join Optimizations in DBMS	2023	SIGMOD
3	4,113	A genetic approach for random testing of database systems	2007	VLDB
4	4,847	Explaining Wrong Queries Using Small Examples	2019	SIGMOD
5	747	QAGen: Generating Query-Aware Test Databases	2007	SIGMOD
6	11,644	Demonstration of the VeriEQL Equivalence Checker for Complex SQL Queries	2024	VLDB
7	5,155	An In-Depth Benchmarking of Text-to-SQL Systems	2021	SIGMOD
8	10,129	ParSEval: Plan-aware Test Database Generation for SQL Equivalence Evaluation	2025	VLDB
9	5,235	Test Data for Relational Queries (Extended abstract)	1986	PODS
10	1,890	Generating Targeted Queries for Database Testing	2008	SIGMOD