Pith. sign in

REVIEW 9 cited by

A Survey on Employing Large Language Models for Text-to-SQL Tasks

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 2407.15186 v5 pith:PJNQJQD3 submitted 2024-07-21 cs.CL

classification cs.CL
keywords largemethodsmodelscomprehensivelanguagellm-basedsurveytext-to-sql
verification ladder T0 review T1 audit T2 compute T3 formal

Signed reviews

No signed human review yet.

0 comments
read the original abstract

With the development of the Large Language Models (LLMs), a large range of LLM-based Text-to-SQL(Text2SQL) methods have emerged. This survey provides a comprehensive review of LLM-based Text2SQL studies. We first enumerate classic benchmarks and evaluation metrics. For the two mainstream methods, prompt engineering and finetuning, we introduce a comprehensive taxonomy and offer practical insights into each subcategory. We present an overall analysis of the above methods and various models evaluated on well-known datasets and extract some characteristics. Finally, we discuss the challenges and future directions in this field.

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. Investigating the (De)Composition Capabilities of Large Language Models in Natural-to-Formal Language Conversion

    cs.CL 2025-01 conditional novelty 7.0 of 10

    LLMs show measurable deficiencies in both decomposition and composition during natural-to-formal conversion, with decomposition errors dominating, under the new DEDC evaluation framework.

  2. SPOT: Bridging Natural Language and Geospatial Search for Investigative Journalists

    cs.IR 2025-06 conditional novelty 6.0 of 10

    SPOT converts natural-language scene descriptions into structured OpenStreetMap queries via a fine-tuned LLaMA 3 model and semantic tag bundles, reporting state-of-the-art query-interpretation accuracy on a 195-query ...

  3. SEED: Enhancing Text-to-SQL Performance and Practical Usability Through Automatic Evidence Generation

    cs.CL 2025-06 conditional novelty 6.0 of 10

    SEED automatically generates evidence from database schemas, descriptions, and sampled values, improving text-to-SQL accuracy in no-evidence settings.

  4. Auto-Cypher: Improving LLMs on Cypher generation via LLM-supervised generation-verification framework

    cs.CL 2024-12 conditional novelty 6.0 of 10

    An LLM-supervised pipeline that reverse-fills synthetic Neo4j databases to validate generated Cypher queries produces a 29.8k-example training set that boosts open-source LLM Text2Cypher accuracy.

  5. Towards Action Hijacking of Large Language Model-based Agent

    cs.CR 2024-12 conditional novelty 6.0 of 10

    A RAG-based LLM application can be induced to assemble harmful SQL, code, or medical action plans from knowledge already stored in its database, with the user prompt itself carrying no forbidden words.

  6. Bootstrapping Learned Cost Models with Synthetic SQL Queries

    cs.DB 2025-08 conditional novelty 5.0 of 10

    LLM-based synthetic SQL generation can train a learned cost model with fewer, more diverse queries than mechanical generation, though the measured accuracy gains are small and the comparison is not matched by training size.

  7. Meta-aware Learning in text-to-SQL Large Language Model

    cs.AI 2025-05 conditional novelty 4.0 of 10

    Combining schema, chain-of-thought, metadata knowledge, and tokenized prompt structures during fine-tuning improves text-to-SQL execution accuracy on private business databases compared to schema-only fine-tuning.

  8. Balancing Content Size in RAG-Text2SQL System

    cs.IR 2025-01 conditional novelty 4.0 of 10

    Adding more schema descriptions and examples to retrieved documents improves table retrieval but increases SQL query errors in a Text2SQL model, with the best balance at medium document richness.

  9. A Survey of Large Language Model-Based Generative AI for Text-to-SQL: Benchmarks, Applications, Use Cases, and Challenges

    cs.AI 2024-12 conditional

    A high-level review of benchmarks, models, applications, and challenges in LLM-based text-to-SQL, with no new experiments or methods.

Pith tools