Pith. sign in

Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsing

1 Pith paper cite this work. Polarity classification is still indexing.

1 Pith paper citing it
abstract

Research on parsing language to SQL has largely ignored the structure of the database (DB) schema, either because the DB was very simple, or because it was observed at both training and test time. In Spider, a recently-released text-to-SQL dataset, new and complex DBs are given at test time, and so the structure of the DB schema can inform the predicted SQL query. In this paper, we present an encoder-decoder semantic parser, where the structure of the DB schema is encoded with a graph neural network, and this representation is later used at both encoding and decoding time. Evaluation shows that encoding the schema structure improves our parser accuracy from 33.8% to 39.4%, dramatically above the current state of the art, which is at 19.7%.

fields

cs.CL 1

years

2024 1

verdicts

CONDITIONAL 1

representative citing papers

citing papers explorer

Showing 1 of 1 citing paper.

  • ROUTE: Robust Multitask Tuning and Collaboration for Text-to-SQL cs.CL · 2024-12-13 · conditional · none · ref 2 · internal anchor

    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.