Pith. sign in

REVIEW 9 cited by

DTS-SQL: Decomposed Text-to-SQL with Small Large Language Models

Not yet reviewed by Pith; the record is open.

This paper has not been read by Pith yet. Machine review is queued; the pith claim, tier, and objections will appear here once it completes.

SPECIMEN: schema-true, not a live event

T0 review · schema-true

One-sentence machine reading of the paper's core claim.

pith:XXXXXXXX · record.json · timestamp

arxiv 2402.01117 v1 pith:L3BSYQDB submitted 2024-02-02 cs.CL cs.DBcs.HC

classification cs.CLcs.DBcs.HC
keywords modelslargeproprietarysmallapproachlanguagellmsopen-source
verification ladder T0 review T1 audit T2 compute T3 formal
0 comments
read the original abstract

Leading models for the text-to-SQL task heavily rely on proprietary Large Language Models (LLMs), posing concerns over data privacy. Closing the performance gap between small open-source models and large proprietary models is crucial to mitigate this reliance. To this end, we introduce a novel two-stage fine-tuning approach that decomposes the task into two simpler tasks. Through comprehensive evaluation on two large cross-domain datasets and two small LLMs, we show that this approach improves execution accuracy by 3 to 7 percent, effectively aligning the performance of open-source models with their proprietary counterparts.

Discussion (0). Continue with ORCID to comment.

Forward citations

Cited by 9 Pith papers

Reviewed papers in the Pith corpus that reference this work. Sorted by Pith novelty score. Full citation record

  1. SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes

    cs.CL 2025-06 conditional novelty 6.0 of 10

    SDE-SQL improves text-to-SQL accuracy by having the model generate and execute exploratory SQL probes to learn database contents before and while writing the final query.

  2. Extractive Schema Linking for Text-to-SQL

    cs.DB 2025-01 conditional novelty 6.0 of 10

    Extractive schema linking with decoder-only LLMs beats generative and cross-encoder baselines on Spider and BIRD while running more than twenty times faster than generative linking.

  3. SchemaGraphSQL: Efficient Schema Linking with Pathfinding Graph Algorithms for Text-to-SQL on Large-Scale Databases

    cs.CL 2025-05 conditional novelty 5.0 of 10

    By taking the union of all shortest paths between LLM-identified source and destination tables, SchemaGraphSQL reaches 95.71% table recall and 62.91% execution accuracy on BIRD dev, but the SOTA framing depends on rec...

  4. A Plug-and-Play Natural Language Rewriter for Natural Language to SQL

    cs.DB 2024-12 conditional novelty 5.0 of 10

    A multi-agent LLM module that checks, reflects on, and rewrites flawed questions yields small average execution-accuracy gains (1.6% Spider, 2.0% BIRD) on NL2SQL dev sets.

  5. Solid-SQL: Enhanced Schema-linking based In-context Learning for Robust Text-to-SQL

    cs.CL 2024-12 conditional novelty 5.0 of 10

    Solid-SQL reports higher SQL execution accuracy on Spider, Bird, and perturbed variants by strengthening schema linking and example retrieval before LLM-based SQL generation.

  6. ROUTE: Robust Multitask Tuning and Collaboration for Text-to-SQL

    cs.CL 2024-12 conditional novelty 5.0 of 10

    Multitask supervised fine-tuning plus collaborative prompting on schema linking, noise correction, and continuation writing lifts open-source LLM Text2SQL accuracy on SPIDER and BIRD.

  7. Towards Automated Cross-domain Exploratory Data Analysis through Large Language Models

    cs.DB 2024-12 conditional novelty 5.0 of 10

    TiInsight automates cross-domain data exploration by summarizing database schemas with LLMs, generating SQL, and recommending charts, achieving 86.3% execution accuracy on Spider and state-of-the-art results on Bird.

  8. Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities

    cs.CL 2025-05 conditional novelty 4.0 of 10

    A systematic review organizing LLM-based text-to-SQL methods into pre-processing, in-context learning, fine-tuning, and post-processing paradigms, with a catalog of datasets, metrics, challenges, and future directions.

  9. PSM-SQL: Progressive Schema Learning with Multi-granularity Semantics for Text-to-SQL

    cs.DB 2025-02 reject novelty 4.0 of 10

    PSM-SQL iteratively filters tables and columns for text-to-SQL, but its best reported numbers come from a two-module ablation, not from the full three-level multi-granularity method described in the paper.

Pith tools