JD Tech
JD Tech
Aug 20, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy with J‑Schema, Iterative DPO, and Self‑Consistency

This article examines the evolution of Text-to-SQL, introduces the J‑Schema representation and chain-of-thought prompting, applies iterative DPO training and self-consistency voting, and demonstrates how these techniques raise execution accuracy on the BIRD benchmark from 56.6% to 69.2%.

BIRD BenchmarkIterative DPOJ-Schema
0 likes · 11 min read
Boosting Text-to-SQL Accuracy with J‑Schema, Iterative DPO, and Self‑Consistency
JD Cloud Developers
JD Cloud Developers
Aug 14, 2025 · Artificial Intelligence

Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency

This article presents a comprehensive study on improving Text-to-SQL performance by introducing J‑Schema for structured schema representation, applying iterative Direct Preference Optimization (DPO) training, and leveraging self‑consistency voting mechanisms, achieving up to a 12% accuracy gain on the BIRD benchmark.

Database QAIterative DPOJ-Schema
0 likes · 10 min read
Boosting Text-to-SQL Accuracy: J‑Schema, Iterative DPO, and Self‑Consistency