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: 7618
Venue: SIGMOD
Year: 2026
Pagerank: 5.093636e-05
Overall Rank: 10,406 | 28.61%
DOI: 10.1145/3769832

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

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 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

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,362	Execution Strategies for SQL Subqueries	2007	SIGMOD	0.00011032204
1,829	Axiomatic Foundations and Algorithms for Deciding Semantic Equivalences of SQL Queries	2018	VLDB	9.6671311e-05
3,769	Proving Query Equivalence Using Linear Integer Arithmetic	2023	SIGMOD	7.1403543e-05
6,872	Efficient Regression Tests for Database Applications	2005	CIDR	5.7496345e-05

Semantically Similar Papers

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