Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing
Not on the map. Why?
Abstract (arXiv)
The importance of building text-to-SQL parsers which can be applied to new databases has long been acknowledged, and a critical step to achieve this goal is schema linking, i.e., properly recognizing mentions of unseen columns or tables when generating SQLs. In this work, we propose a novel framework to elicit relational structures from large-scale pre-trained language models (PLMs) via a probing procedure based on Poincar'e distance metric, and use the induced relations to augment current graph-based parsers for better schema linking. Compared with commonly-used rule-based methods for schema linking, we found that probing relations can robustly capture semantic correspondences, even when surface forms of mentions and entities differ. Moreover, our probing procedure is entirely unsupervised and requires no additional parameters. Extensive experiments show that our framework sets new state-of-the-art performance on three benchmarks. We empirically verify that our probing procedure can indeed find desired relational structures through qualitative analysis. Our code can be found at https://github.com/AlibabaResearch/DAMO-ConvAI.
Key facts. Cited by 30 papers in the map (data through 7 Oct 2026). Builds on 48 of its 59 references that are in the map. First posted on arXiv 28 Jun 2022.
Builds on
48 of 59 references.
References · 48
- 2018BERT: Pre-training of Deep Bidirectional Transformers for Language Understandingcited by 40,204
- 2014Adam: A Method for Stochastic Optimizationcited by 36,960
- 2019Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformercited by 14,491
- 2019RoBERTa: A Robustly Optimized BERT Pretraining Approachcited by 13,266
- 2016Layer Normalizationcited by 5,579
- 2019Language Models as Knowledge Bases?cited by 1,922
- 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,120
- 2016Geometric deep learning: going beyond Euclidean datacited by 1,042
- 2020A Primer in BERTology: What we know about how BERT workscited by 807
- 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 679
- 2017Poincar'e Embeddings for Learning Hierarchical Representationscited by 674
- 2019Designing and Interpreting Probes with Control Taskscited by 608
36 more
- 2019TabFact: A Large-scale Dataset for Table-based Fact Verificationcited by 425
- 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 420
- 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
- 2019Hyperbolic Graph Convolutional Neural Networkscited by 400
- 2020TaBERT: Pretraining for Joint Understanding of Textual and Tabular Datacited by 395
- 2018Hyperbolic Neural Networkscited by 393
- 2019Linguistic Knowledge and Transferability of Contextual Representationscited by 382
- 2019Revealing the Dark Secrets of BERTcited by 300
- 2021TAPEX: Table Pre-training via Learning a Neural SQL Executorcited by 233
- 2019Visualizing and Measuring the Geometry of BERTcited by 215
- 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
- 2020GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsingcited by 171
- 2020Beyond I.I.D.: Three Levels of Generalization for Question Answering on Knowledge Basescited by 169
- 2017What do Neural Machine Translation Models Learn about Morphology?cited by 165
- 2018Poincar'e GloVe: Hyperbolic Word Embeddingscited by 155
- 2020DART: Open-Domain Structured Data Record to Text Generationcited by 144
- 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
- 2021Towards Robustness of Text-to-SQL Models against Synonym Substitutioncited by 110
- 2020Perturbed Masking: Parameter-free Probing for Analyzing and Interpreting BERTcited by 109
- 2021GALAXY: A Generative Pre-trained Model for Task-Oriented Dialog with Semi-Supervised Learning and Explicit Policy Injectioncited by 102
- 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
- 2018TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generationcited by 81
- 2019Editing-Based SQL Query Generation for Cross-Domain Context-Dependent Questionscited by 80
- 2019Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsingcited by 74
- 2020Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Trainingcited by 65
- 2020RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databasescited by 63
- 2021Probing BERT in Hyperbolic Spacescited by 50
- 2020Meta-Learning for Domain Generalization in Semantic Parsingcited by 41
- 2021Does syntax matter? A strong baseline for Aspect-based Sentiment Analysis with RoBERTacited by 41
- 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
- 2021ShadowGNN: Graph Projection Neural Network for Text-to-SQL Parsercited by 35
- 2021Preview, Attend and Review: Schema-Aware Curriculum Learning for Multi-Domain Dialog State Trackingcited by 35
- 2021Awakening Latent Grounding from Pretrained Language Models for Semantic Parsingcited by 28
- 2022Duplex Conversation: Towards Human-like Interaction in Spoken Dialogue Systemscited by 28
- 2021Improving Text-to-SQL with Schema Dependency Learningcited by 25
- 2020Heads-up! Unsupervised Constituency Parsing via Self-Attention Headscited by 12
Built on by
Citing papers per year: 2022: 10; 2023: 9; 2024: 6; 2025: 4; 2026: 1.
30 papers.
Sort:
By area:
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 378
- 2023Large Language Models are Versatile Decomposers: Decompose Evidence and Questions for Table-based Reasoningcited by 177
- 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 118
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
- 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsingcited by 19
- 2025Reliable Text-to-SQL with Adaptive Abstentioncited by 19
- 2022Estimating Soft Labels for Out-of-Domain Intent Detectioncited by 11
18 more
- 2022Eliciting Knowledge from Large Pre-Trained Models for Unsupervised Knowledge-Grounded Conversationcited by 10
- 2025When TableQA Meets Noise: A Dual Denoising Framework for Complex Questions and Large-scale Tablescited by 10
- 2023Towards Understanding the Generalization of Medical Text-to-SQL Models and Datasetscited by 9
- 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generationcited by 9
- 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parserscited by 7
- 2022Towards Generalizable and Robust Text-to-SQL Parsingcited by 7
- 2023SPRING: Situated Conversation Agent Pretrained with Multimodal Questions from Incremental Layout Graphcited by 6
- 2023Benchmarking Diverse-Modal Entity Linking with Generative Modelscited by 5
- 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Modelscited by 5
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translationcited by 3
- 2022Structural Bias for Aspect Sentiment Triplet Extractioncited by 2
- 2022Graph-to-Text Generation with Dynamic Structure Pruningcited by 2
- 2022Dial2vec: Self-Guided Contrastive Learning of Unsupervised Dialogue Embeddingscited by 2
- 2024DataVisT5: A Pre-trained Language Model for Jointly Understanding Text and Data Visualizationcited by 2
- 2022DocuT5: Seq2seq SQL Generation with Table Documentationcited by 1
- 2024Beyond Text-to-SQL for IoT Defense: A Comprehensive Framework for Querying and Classifying IoT Threatscited by 1
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Taskscited by 1
- 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Modelcited by 0
- 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Model13 May 2026
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025When TableQA Meets Noise: A Dual Denoising Framework for Complex Questions and Large-scale Tables22 Sep 2025
- 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generation18 Feb 2025
- 2025Reliable Text-to-SQL with Adaptive Abstention18 Jan 2025
- 2024DataVisT5: A Pre-trained Language Model for Jointly Understanding Text and Data Visualization14 Aug 2024
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?9 Aug 2024
- 2024Beyond Text-to-SQL for IoT Defense: A Comprehensive Framework for Querying and Classifying IoT Threats25 Jun 2024
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL12 Jun 2024
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generation24 May 2024
- 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Models4 May 2024
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translation27 Oct 2023
18 more
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluation29 Aug 2023
- 2023Benchmarking Diverse-Modal Entity Linking with Generative Models27 May 2023
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLs4 May 2023
- 2023Towards Understanding the Generalization of Medical Text-to-SQL Models and Datasets22 Mar 2023
- 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capability12 Mar 2023
- 2023Large Language Models are Versatile Decomposers: Decompose Evidence and Questions for Table-based Reasoning31 Jan 2023
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsing18 Jan 2023
- 2023SPRING: Situated Conversation Agent Pretrained with Multimodal Questions from Incremental Layout Graph5 Jan 2023
- 2022DocuT5: Seq2seq SQL Generation with Table Documentation11 Nov 2022
- 2022Estimating Soft Labels for Out-of-Domain Intent Detection10 Nov 2022
- 2022Eliciting Knowledge from Large Pre-Trained Models for Unsupervised Knowledge-Grounded Conversation3 Nov 2022
- 2022Dial2vec: Self-Guided Contrastive Learning of Unsupervised Dialogue Embeddings27 Oct 2022
- 2022Towards Generalizable and Robust Text-to-SQL Parsing23 Oct 2022
- 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsing21 Oct 2022
- 2022Graph-to-Text Generation with Dynamic Structure Pruning15 Sep 2022
- 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parsers14 Sep 2022
- 2022Structural Bias for Aspect Sentiment Triplet Extraction2 Sep 2022
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directions29 Aug 2022
- 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
- 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 378
- 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 118
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
- 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
- 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
- 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsingcited by 19
- 2025Reliable Text-to-SQL with Adaptive Abstentioncited by 19
- 2022Estimating Soft Labels for Out-of-Domain Intent Detectioncited by 11
- 2022Eliciting Knowledge from Large Pre-Trained Models for Unsupervised Knowledge-Grounded Conversationcited by 10
12 most cited of 29 All 29 (JSON)
- 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Model13 May 2026
- 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Tasks28 Oct 2025
- 2025When TableQA Meets Noise: A Dual Denoising Framework for Complex Questions and Large-scale Tables22 Sep 2025
- 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generation18 Feb 2025
- 2025Reliable Text-to-SQL with Adaptive Abstention18 Jan 2025
- 2024DataVisT5: A Pre-trained Language Model for Jointly Understanding Text and Data Visualization14 Aug 2024
- 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?9 Aug 2024
- 2024Beyond Text-to-SQL for IoT Defense: A Comprehensive Framework for Querying and Classifying IoT Threats25 Jun 2024
- 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQL12 Jun 2024
- 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generation24 May 2024
- 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Models4 May 2024
- 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translation27 Oct 2023
12 newest of 29 All 29 (JSON)