Search papers, labs, and topics across Lattice.
The paper introduces ReAct-SQL, a streamlined text-to-SQL generation framework that leverages iterative reasoning and a constrained action space defined by a typed Domain-Specific Language (DSL) of 15 relational operations. This approach significantly reduces latency and engineering complexity while achieving competitive accuracy of 84.5% and 73.9% on the BIRD mini-dev and EHR-SQL benchmarks, respectively. Key findings reveal that the iterative nature enhances grounding and that the DSL contributes to improved compositional reliability, outperforming more complex systems while being up to 8 times faster.
ReAct-SQL matches the accuracy of complex text-to-SQL systems while being up to 8 times faster and simpler.
Modern text-to-SQL systems have become increasingly elaborate, relying on schema-linking modules, retrieval-augmented prompting, candidate generation, and multi-stage refinement pipelines. While effective, these additions introduce substantial latency and engineering overhead. To this end, we present \textbf{ReAct-SQL}, a simple yet effective zero-shot ReAct-style framework built solely on iterative reasoning and a constrained action space defined by a typed Domain-Specific Language (DSL) of 15 relational operations, rather than free-form SQL generation. The model incrementally issues DSL calls, observes compiled-SQL execution feedback, and revises its reasoning through interaction. On corrected BIRD mini-dev and EHR-SQL, ReAct-SQL achieves \textbf{84.5\%} and \textbf{73.9\%} accuracy, respectively, matching substantially more elaborate baselines while running up to $8\times$ faster. Incremental ablations further show that iteration primarily improves grounding, while the DSL improves compositional reliability.
