← Research building on SQLancer

Jiale Lao, Immanuel Trummer. 2025. Proceedings of the ACM on Management of Data.

Read the paper · doi:10.1145/3786699 · arXiv:2507.06192

What this paper does with SQLancer

SQLancer is cited as prior work on generating diverse queries for testing and debugging, with its query plan guidance described as feedback-guided generation aiming at diverse execution plans. SQLBarber's goal is realistic workloads rather than bug finding, so the two are related but not compared. SQLBarber generates customised, realistic SQL workloads with large language models. Real queries are hard to obtain for privacy reasons and existing generators offer little customisation or ability to meet realistic constraints. SQLBarber provides a declarative interface, removes the need to write SQL templates by hand while accepting natural-language constraints, and adds a self-correction pipeline that profiles, refines and prunes templates by query cost. The authors open-source ten benchmarks built from Snowflake and Amazon Redshift statistics. Written by claude-opus-5 from the 3 places this paper refers to SQLancer. The quotations below are the paper's own words, stored verbatim when the text was extracted.

How it was classified

uses infrastructure — no

SQLancer is cited, not used; nothing in the mentions describes reusing its code.

extends technique — no

No technique is extended; the citation is background.

compares with — no

No empirical comparison against SQLancer is reported in the mentions.

describes as state of the art — no

The citation does not characterise SQLancer as the state of the art.

SQLancer publications it cites (1)

Bibliography entries that resolved to a SQLancer publication, or to a paper by one of the project's authors. A sentence citing one of these numbers is a reference to SQLancer even when it never writes the name.

#EntryMatched as
2 Jinsheng Ba and Manuel Rigger. 2023. Testing database engines via query plan guidance. In2023 IEEE/ACM 45th International Conference on Software Engineering (ICSE). IEEE, 2060–2071. sqlancer publication · QPG

Every place it refers to SQLancer (3)

3 sentences, each stored verbatim from the extracted text with where it was found and how. “Citation marker” means the sentence names no tool at all and was reached through a reference number that resolved to a SQLancer publication.

Id Sentence Found by Where
M1 SQLSmith [ 1], SQLancer [ 2], and SQLStorm [ 28] focus on generating diverse queries for testing and debugging. name
background 		1 Introduction
page 1
M2 SQLBarber relates to prior work on generating diverse SQL queries for testing and debugging [ 1,2,28]. citation marker
background 		2 Related Work
page 3
M3 SQLancer [ 2] employs a feedbackguided test generation approach that aims to produce diverse query execution plans, based on the idea that exploring a wide range of plans helps reveal bugs. name
definition 		2 Related Work
page 4

This page is rendered from _data/papers/paper_doi_10_1145_3786699.json, extracted from arxiv. 29 pages, 43 references parsed.