Pith. sign in

REVIEW 6 cited by

RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers

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 1911.04942 v5 pith:OYSBL5TG submitted 2019-11-10 cs.CL cs.AI

RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parsers

classification cs.CL cs.AI
keywords databaseschemaencodinglinkingalignmentframeworkquestionsrat-sql
verification ladder T0 review T1 audit T2 compute T3 formal T4 reserved
0 comments
Share X Bluesky LinkedIn Reddit HN
read the original abstract

When translating natural language questions into SQL queries to answer questions from a database, contemporary semantic parsing models struggle to generalize to unseen database schemas. The generalization challenge lies in (a) encoding the database relations in an accessible way for the semantic parser, and (b) modeling alignment between database columns and their mentions in a given query. We present a unified framework, based on the relation-aware self-attention mechanism, to address schema encoding, schema linking, and feature representation within a text-to-SQL encoder. On the challenging Spider dataset this framework boosts the exact match accuracy to 57.2%, surpassing its best counterparts by 8.7% absolute improvement. Further augmented with BERT, it achieves the new state-of-the-art performance of 65.6% on the Spider leaderboard. In addition, we observe qualitative improvements in the model's understanding of schema linking and alignment. Our implementation will be open-sourced at https://github.com/Microsoft/rat-sql.

discussion (0)

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

Forward citations

Cited by 6 Pith papers

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

  1. SANE Schema-aware Natural-language Evaluation of Biological Data

    cs.CL 2026-06 unverdicted novelty 6.0

    SANE is a new schema-aware benchmark paradigm for text-to-SQL evaluation that demonstrates few-shot LLMs with structured prompting can generate accurate queries on constrained biological data schemas without fine-tuning.

  2. Measuring Coding Challenge Competence With APPS

    cs.SE 2021-05 unverdicted novelty 6.0

    APPS benchmark shows models like GPT-Neo pass roughly 20% of test cases on introductory problems, indicating machine learning is beginning to learn basic coding.

  3. Extending Confidence-Based Text2Cypher with Grammar and Schema Aware Filtering

    cs.CL 2026-05 unverdicted novelty 5.0

    Post-generation grammar and schema filtering on top of confidence scoring raises syntactic validity and execution success for Text2Cypher but increases empty outputs and lowers coverage.

  4. Agent-Agnostic Evaluation of SQL Accuracy in Production Text-to-SQL Systems

    cs.AI 2026-04 unverdicted novelty 5.0

    STEF is a schema-agnostic evaluation framework that scores SQL generation accuracy from natural language inputs using semantic feature alignment and a composite metric.

  5. PaVeRL-SQL: Text-to-SQL via Partial-Match Rewards and Verbal Reinforcement Learning

    cs.AI 2025-09 reject novelty 5.0

    PaVeRL-SQL reports SOTA execution accuracy on Spider2.0-SQLite using partial-match rewards and verbal RL, but overclaims SOTA on Spider and BIRD.

  6. 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...