REVIEW 13 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
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.
Forward citations
Cited by 13 Pith papers
-
Natural Language Access to Domain-Specific Metadata: A Reusable Framework for LLM Query Generation
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.
-
SDE-SQL: Enhancing Text-to-SQL Generation in Large Language Models via Self-Driven Exploration with SQL Probes
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.
-
Knowledge Base Construction for Knowledge-Augmented Text-to-SQL
KAT-SQL constructs a reusable knowledge base for text-to-SQL by expanding training data with LLM-generated knowledge and retrieving/refining the best entries for each query.
-
DCG-SQL: Enhancing In-Context Learning for Text-to-SQL with Deep Contextual Schema Link Graph
DCG-SQL retrieves text-to-SQL demonstrations by embedding a question-to-schema link graph, improving execution accuracy on Spider by up to about 10 points over random demonstrations on small LLMs.
-
ProgramTab: Boosting Table Reasoning of LLMs via Programmatic Paradigm
A Python-preprocessing + CoT-SQL pipeline lets LLMs reason over large, inconsistently formatted tables more accurately than prior prompting baselines.
-
Confidence Estimation for Text-to-SQL in Large Language Models
Consistency-based methods are the most reliable confidence signal for text-to-SQL in black-box LLMs, and executing queries against a database adds a useful correctness signal.
-
SQLord: A Robust Enterprise Text-to-SQL Solution via Reverse Data Generation and Workflow Decomposition
SQLord builds a domain-specific text-to-SQL pipeline using reverse-generated query-SQL training pairs, workflow decomposition, and an LLM-based judge, reporting consistent gains over GPT-4 and open-source baselines.
-
Interactive Text-to-SQL via Expected Information Gain for Disambiguation
An interactive text-to-SQL framework selects clarification questions by expected information gain over a distribution of candidate SQL queries.
-
Exploring the Landscape of Text-to-SQL with Large Language Models: Progresses, Challenges and Opportunities
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.
-
Meta-aware Learning in text-to-SQL Large Language Model
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.
-
Chatting with your ERP: A Recipe
A dual-agent LLM system with a reasoner and critic achieves up to 10/11 expert-validated SQL accuracy on a real ERP database, but the evaluation lacks a baseline and released artifacts.
-
THOR: Transformer Heuristics for On-Demand Retrieval
THOR is an enterprise Text-to-SQL system using LLM agents, schema injection, and a five-retry self-correction loop, evaluated only on seven anecdotal prompts.
-
LLM Inference Enhanced by External Knowledge: A Survey
A survey of methods that enhance LLM inference by integrating external structured knowledge from tables and knowledge graphs.
Discussion (0). Continue with ORCID to comment.