IGSQL: Database Schema Interaction Graph Based Neural Model for Context-Dependent Text-to-SQL Generation
Yitao Cai, Xiaojun Wan
Abstract
Context-dependent text-to-SQL task has drawn much attention in recent years. Previous models on context-dependent text-to-SQL task only concentrate on utilizing historical user inputs. In this work, in addition to using encoders to capture historical information of user inputs, we propose a database schema interaction graph encoder to utilize historicalal information of database schema items. In decoding phase, we introduce a gate mechanism to weigh the importance of different vocabularies and then make the prediction of SQL tokens. We evaluate our model on the benchmark SParC and CoSQL datasets, which are two large complex context-dependent cross-domain text-to-SQL datasets. Our model outperforms previous state-of-the-art model by a large margin and achieves new state-of-the-art results on the two datasets. The comparison and ablation results demonstrate the efficacy of our model and the usefulness of the database schema interaction graph encoder.
Ask about this paper
Your agent reads all of it.
Lune indexed this paper to the last equation, along with the top-tier papers that cite it. Ask a question and the answer quotes them.
Cited by top-tier papers8
- RASAT: Integrating Relational Structures into Pretrained Seq2Seq Model for Text-to-SQLJiexing Qi, Jingyao Tang, Ziwei He, Xiangpeng Wan et al.EMNLP 2022 · 73 citations
- Towards Robustness of Text-to-SQL Models Against Natural and Realistic Adversarial Table PerturbationXinyu Pi, Bing Wang, Yan Gao, Jiaqi Guo et al.ACL 2022 · 41 citations
- Interactive Text-to-SQL Generation via Editable Step-by-Step ExplanationsYuan Tian, Zheng Zhang, Zheng Ning, Toby Jia-Jun Li et al.EMNLP 2023 · 14 citations
- MIGA: A Unified Multi-Task Generation Framework for Conversational Text-to-SQLYingwen Fu, Wenjie Ou, Zhou Yu, Yue LinAAAI 2023 · 14 citations
- MTSQL-R1: Towards Long-Horizon Multi-Turn Text-to-SQL via Agentic TrainingTaicheng Guo, Hai Wang, Chaochun Liu, Mohsen Golalikhani et al.ACL 2026 · 5 citations
Builds on1
Related papers
- Dynamic Hybrid Relation Exploration Network for Cross-Domain Context-Dependent Semantic ParsingBinyuan Hui, Ruiying Geng, Qiyu Ren, Binhua Li et al.AAAI 2021 · 52 citations
- Tracking Interaction States for Multi-Turn Text-to-SQL Semantic ParsingRunze Wang, Zhen-Hua Ling, Jingbo Zhou, Yu HuAAAI 2021 · 29 citations
- RESDSQL: Decoupling Schema Linking and Skeleton Parsing for Text-to-SQLHaoyang Li, Jing Zhang, Cuiping Li, Hong ChenAAAI 2023 · 343 citations
- SADGA: Structure-Aware Dual Graph Aggregation Network for Text-to-SQLRuichu Cai, Jinjie Yuan, Boyan Xu, Zhifeng HaoNeurIPS 2021 · 90 citations
- LGESQL: Line Graph Enhanced Text-to-SQL Model with Mixed Local and Non-Local RelationsRuisheng Cao, Lu Chen, Zhi Chen, Yanbin Zhao et al.ACL 2021
