Pith. sign in

REVIEW 15 cited by

Evaluating the Text-to-SQL Capabilities of 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 2204.00498 v1 pith:SMWCGYZL submitted 2022-03-15 cs.CL cs.DBcs.LG

Evaluating the Text-to-SQL Capabilities of Large Language Models

classification cs.CL cs.DBcs.LG
keywords codexcapabilitiesexampleslanguagemodelsperformtext-to-sqlanalyze
verification ladder T0 review T1 audit T2 compute T3 formal T4 reserved
0 comments
read the original abstract

We perform an empirical evaluation of Text-to-SQL capabilities of the Codex language model. We find that, without any finetuning, Codex is a strong baseline on the Spider benchmark; we also analyze the failure modes of Codex in this setting. Furthermore, we demonstrate on the GeoQuery and Scholar benchmarks that a small number of in-domain examples provided in the prompt enables Codex to perform better than state-of-the-art models finetuned on such few-shot examples.

discussion (0)

Sign in with ORCID, Apple, or X to comment. Anyone can read and Pith papers without signing in.

Forward citations

Cited by 15 Pith papers

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

  1. The Power of Order: Fooling LLMs with Adversarial Table Permutations

    cs.LG 2026-05 unverdicted novelty 7.0

    Semantically invariant row and column permutations can fool LLMs on tabular tasks, and a new gradient-based attack called ATP finds such permutations to significantly degrade performance across models.

  2. Natural Language Access to Domain-Specific Metadata: A Reusable Framework for LLM Query Generation

    cs.DB 2026-07 conditional novelty 6.0

    With an OWL ontology using readable names and annotations, a local Qwen3.6-27B model generates SPARQL for 21 expert questions with 100% accuracy, versus 57% for auto-generated SQL.

  3. The Power of Order: Fooling LLMs with Adversarial Table Permutations

    cs.LG 2026-05 unverdicted novelty 6.0

    Semantically invariant row and column permutations in tables can cause LLMs to output incorrect answers, and a gradient-based attack called ATP efficiently finds such permutations that degrade performance across many models.

  4. CFMS: A Coarse-to-Fine Multimodal Synthesis Framework for Enhanced Tabular Reasoning

    cs.AI 2026-04 unverdicted novelty 6.0

    CFMS is a coarse-to-fine framework that uses MLLMs to create a multi-perspective knowledge tuple as a reasoning map for symbolic table operations, yielding competitive accuracy on WikiTQ and TabFact.

  5. AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views

    cs.DB 2026-04 unverdicted novelty 6.0

    AV-SQL uses a pipeline of LLM agents to generate intermediate CTE views that decompose complex Text-to-SQL queries, reaching 70.38% execution accuracy on Spider 2.0.

  6. SQLStructEval: Structural Evaluation of LLM Text-to-SQL Generation

    cs.CL 2026-04 unverdicted novelty 6.0

    LLMs produce structurally diverse SQL queries for identical inputs on the Spider benchmark even when execution is correct, and a compile-style pipeline improves both accuracy and structural consistency.

  7. Teaching Large Language Models to Self-Debug

    cs.CL 2023-04 unverdicted novelty 6.0

    Self-Debugging teaches LLMs to identify and fix their own code errors through rubber-duck-style natural language explanations and execution feedback, delivering 2-12% gains over baselines on Spider, TransCoder, and MBPP.

  8. ProgramTab: Boosting Table Reasoning of LLMs via Programmatic Paradigm

    cs.CL 2026-07 conditional novelty 5.0

    A Python-preprocessing + CoT-SQL pipeline lets LLMs reason over large, inconsistently formatted tables more accurately than prior prompting baselines.

  9. Adapt to Thrive! Adaptive Power-Mean Policy Optimization for Improved LLM Reasoning

    cs.CL 2026-04 unverdicted novelty 5.0

    APMPO boosts average Pass@1 scores on math reasoning benchmarks by 3 points over GRPO by using an adaptive power-mean policy objective and feedback-driven clipping bounds in RLVR training.

  10. Free Energy-Driven Reinforcement Learning with Adaptive Advantage Shaping for Unsupervised Reasoning in LLMs

    cs.CL 2026-04 unverdicted novelty 5.0

    FREIA applies free energy principles and adaptive advantage shaping to unsupervised RL, outperforming baselines by 0.5-3.5 Pass@1 points on math reasoning with a 1.5B model.

  11. CHESS: Contextual Harnessing for Efficient SQL Synthesis

    cs.LG 2024-05 conditional novelty 5.0

    CHESS deploys four LLM agents to retrieve information, prune schemas, generate refined SQL candidates, and validate via unit tests, reporting up to 71.10% accuracy on BIRD with 83% fewer calls than leading proprietary...

  12. ClinQueryAgent: A Conversational Agent for Population Health Management

    cs.IR 2026-04 unverdicted novelty 4.0

    The paper introduces ClinQueryAgent, a conversational agent that converts natural language queries into database queries for population health management while keeping patient data secure, and reports its use by 128 s...

  13. Retrieve Only Relevant Tables Whether Few or Many: Adaptive Table Retrieval Method

    cs.IR 2026-04 unverdicted novelty 4.0

    An adaptive thresholding mechanism combined with sliding-window reranking retrieves a query-dependent number of tables from large corpora, improving retrieval and downstream text-to-SQL performance on Spider, BIRD, an...

  14. When TableQA Meets Noise: A Dual Denoising Framework for Complex Questions and Large-scale Tables

    cs.CL 2025-09 unverdicted novelty 4.0

    EnoTab is a dual denoising framework for TableQA that performs evidence-based question denoising via semantic unit decomposition and evidence tree-guided table pruning with post-order rollback to improve performance o...

  15. A Survey on Large Language Models for Code Generation

    cs.CL 2024-06 unverdicted novelty 3.0

    A systematic literature review that organizes recent work on LLMs for code generation into a taxonomy covering data curation, model advances, evaluations, ethics, environmental impact, and applications, with benchmark...