mlsanityData to 7 Oct 2026

Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsing

arXiv 2206.14017 ↗First posted 28 Jun 2022cs.CLcited by 30

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

  1. 2018BERT: Pre-training of Deep Bidirectional Transformers for Language Understandingcited by 40,204
  2. 2014Adam: A Method for Stochastic Optimizationcited by 36,960
  3. 2019Exploring the Limits of Transfer Learning with a Unified Text-to-Text Transformercited by 14,491
  4. 2019RoBERTa: A Robustly Optimized BERT Pretraining Approachcited by 13,266
  5. 2016Layer Normalizationcited by 5,579
  6. 2019Language Models as Knowledge Bases?cited by 1,922
  7. 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,120
  8. 2016Geometric deep learning: going beyond Euclidean datacited by 1,042
  9. 2020A Primer in BERTology: What we know about how BERT workscited by 807
  10. 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 679
  11. 2017Poincar'e Embeddings for Learning Hierarchical Representationscited by 674
  12. 2019Designing and Interpreting Probes with Control Taskscited by 608
36 more
  1. 2019TabFact: A Large-scale Dataset for Table-based Fact Verificationcited by 425
  2. 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 420
  3. 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 402
  4. 2019Hyperbolic Graph Convolutional Neural Networkscited by 400
  5. 2020TaBERT: Pretraining for Joint Understanding of Textual and Tabular Datacited by 395
  6. 2018Hyperbolic Neural Networkscited by 393
  7. 2019Linguistic Knowledge and Transferability of Contextual Representationscited by 382
  8. 2019Revealing the Dark Secrets of BERTcited by 300
  9. 2021TAPEX: Table Pre-training via Learning a Neural SQL Executorcited by 233
  10. 2019Visualizing and Measuring the Geometry of BERTcited by 215
  11. 2019Towards Complex Text-to-SQL in Cross-Domain Database with Intermediate Representationcited by 210
  12. 2020GraPPa: Grammar-Augmented Pre-Training for Table Semantic Parsingcited by 171
  13. 2020Beyond I.I.D.: Three Levels of Generalization for Question Answering on Knowledge Basescited by 169
  14. 2017What do Neural Machine Translation Models Learn about Morphology?cited by 165
  15. 2018Poincar'e GloVe: Hyperbolic Word Embeddingscited by 155
  16. 2020DART: Open-Domain Structured Data Record to Text Generationcited by 144
  17. 2021LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local Relationscited by 119
  18. 2021Towards Robustness of Text-to-SQL Models against Synonym Substitutioncited by 110
  19. 2020Perturbed Masking: Parameter-free Probing for Analyzing and Interpreting BERTcited by 109
  20. 2021GALAXY: A Generative Pre-trained Model for Task-Oriented Dialog with Semi-Supervised Learning and Explicit Policy Injectioncited by 102
  21. 2021Exploring Underexplored Limitations of Cross-Domain Text-to-SQL Generalizationcited by 92
  22. 2018TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generationcited by 81
  23. 2019Editing-Based SQL Query Generation for Cross-Domain Context-Dependent Questionscited by 80
  24. 2019Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsingcited by 74
  25. 2020Learning Contextual Representations for Semantic Parsing with Generation-Augmented Pre-Trainingcited by 65
  26. 2020RYANSQL: Recursively Applying Sketch-based Slot Fillings for Complex Text-to-SQL in Cross-Domain Databasescited by 63
  27. 2021Probing BERT in Hyperbolic Spacescited by 50
  28. 2020Meta-Learning for Domain Generalization in Semantic Parsingcited by 41
  29. 2021Does syntax matter? A strong baseline for Aspect-based Sentiment Analysis with RoBERTacited by 41
  30. 2022S2SQL: Injecting Syntax to Question-Schema Interaction Graph Encoder for Text-to-SQL Parserscited by 41
  31. 2021ShadowGNN: Graph Projection Neural Network for Text-to-SQL Parsercited by 35
  32. 2021Preview, Attend and Review: Schema-Aware Curriculum Learning for Multi-Domain Dialog State Trackingcited by 35
  33. 2021Awakening Latent Grounding from Pretrained Language Models for Semantic Parsingcited by 28
  34. 2022Duplex Conversation: Towards Human-like Interaction in Spoken Dialogue Systemscited by 28
  35. 2021Improving Text-to-SQL with Schema Dependency Learningcited by 25
  36. 2020Heads-up! Unsupervised Constituency Parsing via Self-Attention Headscited by 12

Built on by

Cited by year (2026 to 7 Oct)

Citing papers per year: 2022: 10; 2023: 9; 2024: 6; 2025: 4; 2026: 1.

30 papers.

Sort:

By area:

  1. 2023Can LLM Already Serve as A Database Interface? A BIg Bench for Large-Scale Database Grounded Text-to-SQLscited by 667
  2. 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 378
  3. 2023Large Language Models are Versatile Decomposers: Decompose Evidence and Questions for Table-based Reasoningcited by 177
  4. 2023A comprehensive evaluation of ChatGPT's zero-shot Text-to-SQL capabilitycited by 118
  5. 2024Next-Generation Database Interfaces: A Survey of LLM-based Text-to-SQLcited by 118
  6. 2023Graphix-T5: Mixing Pre-Trained Transformers with Graph-Aware Layers for Text-to-SQL Parsingcited by 93
  7. 2024A Survey of Text-to-SQL in the Era of LLMs: Where are we, and where are we going?cited by 54
  8. 2022A Survey on Text-to-SQL Parsing: Concepts, Methods, and Future Directionscited by 51
  9. 2024Before Generation, Align it! A Novel and Effective Strategy for Mitigating Hallucinations in Text-to-SQL Generationcited by 49
  10. 2022STAR: SQL Guided Pre-Training for Context-dependent Text-to-SQL Parsingcited by 19
  11. 2025Reliable Text-to-SQL with Adaptive Abstentioncited by 19
  12. 2022Estimating Soft Labels for Out-of-Domain Intent Detectioncited by 11
18 more
  1. 2022Eliciting Knowledge from Large Pre-Trained Models for Unsupervised Knowledge-Grounded Conversationcited by 10
  2. 2025When TableQA Meets Noise: A Dual Denoising Framework for Complex Questions and Large-scale Tablescited by 10
  3. 2023Towards Understanding the Generalization of Medical Text-to-SQL Models and Datasetscited by 9
  4. 2025Knapsack Optimization-based Schema Linking for LLM-based Text-to-SQL Generationcited by 9
  5. 2022SUN: Exploring Intrinsic Uncertainties in Text-to-SQL Parserscited by 7
  6. 2022Towards Generalizable and Robust Text-to-SQL Parsingcited by 7
  7. 2023SPRING: Situated Conversation Agent Pretrained with Multimodal Questions from Incremental Layout Graphcited by 6
  8. 2023Benchmarking Diverse-Modal Entity Linking with Generative Modelscited by 5
  9. 2024Open-SQL Framework: Enhancing Text-to-SQL on Open-source Large Language Modelscited by 5
  10. 2023SQLformer: Deep Auto-Regressive Query Graph Generation for Text-to-SQL Translationcited by 3
  11. 2022Structural Bias for Aspect Sentiment Triplet Extractioncited by 2
  12. 2022Graph-to-Text Generation with Dynamic Structure Pruningcited by 2
  13. 2022Dial2vec: Self-Guided Contrastive Learning of Unsupervised Dialogue Embeddingscited by 2
  14. 2024DataVisT5: A Pre-trained Language Model for Jointly Understanding Text and Data Visualizationcited by 2
  15. 2022DocuT5: Seq2seq SQL Generation with Table Documentationcited by 1
  16. 2024Beyond Text-to-SQL for IoT Defense: A Comprehensive Framework for Querying and Classifying IoT Threatscited by 1
  17. 2025Squrve: A Unified and Modular Framework for Complex Real-World Text-to-SQL Taskscited by 1
  18. 2026Knowledge Distillation for Low-Resource Open-source Text-to-SQL Modelcited by 0