NL2pSQL: Generating Pseudo-SQL Queries from Under-Specified Natural Language Questions (D19-1)
Copied to clipboard
| Challenge: | Existing studies focus on generating SQL codes from natural language questions . however, questions cover more diverse tasks including table manipulation or performance issues . |
| Approach: | They propose a task to generate pSQL codes from natural language questions . they define two new metrics suitable for the task, Canonical-BLEU and SQL-BLUE . |
| Outcome: | The proposed task generates well-formed queries on under-specified database issues. |
Similar Papers
Natural SQL: Making SQL Easier to Infer from Natural Language Specifications (2021.findings-emnlp)
Copied to clipboard
| Challenge: | Existing models that do not support executable SQL generation can generate executable queries. |
| Approach: | They propose an SQL intermediate representation called Natural SQL (NatSQL) they propose to preserve the core functionalities of SQL while simplifying the queries . |
| Outcome: | The proposed model outperforms existing models on a text-to-SQL benchmark . it significantly improves the performance of previous models on the same dataset . |
Semantic Parsing with Syntax- and Table-Aware SQL Generation (P18-1)
Copied to clipboard
Yibo Sun, Duyu Tang, Nan Duan, Jianshu Ji, Guihong Cao, Xiaocheng Feng, Bing Qin, Ting Liu, Ming Zhou
| Challenge: | Existing approaches generate a SQL query word-by-word but results are incorrect or not executable due to mismatch between question words and table contents. |
| Approach: | They propose a generative model to map natural language questions into SQL queries. |
| Outcome: | The proposed model significantly improves state-of-the-art execution accuracy from 69.0% to 74.4% on a large question- SQL dataset. |
Natural Language Interface for Databases Using a Dual-Encoder Model (C18-1)
Copied to clipboard
| Challenge: | Existing approaches to train data-driven natural language interfaces for databases are limited and lack of large datasets is probably the main reason for the lack of complex machine learning approaches. |
| Approach: | They propose a sketch-based two-step neural model for generating structured queries based on a user’s request in natural language. |
| Outcome: | The proposed model improves on two recent large datasets suitable for data-driven solutions for natural language interfaces for databases. |
DeKeyNLU: Enhancing Natural Language to SQL Generation through Task Decomposition and Keyword Extraction (2025.findings-emnlp)
Copied to clipboard
Jian Chen, Zhenyan Chen, Xuming Hu, Peilin Zhou, Yining Hua, Han Fang, Cissy Hing Yee Choy, Xinmei Ke, Jingfeng Luo, Zixuan Yuan
| Challenge: | NL2SQL provides a model-centric paradigm that simplifies database access for non-technical users . challenges such as inaccurate task decomposition and keyword extraction remain major bottlenecks . |
| Approach: | They propose a RAG-based NL2SQL pipeline that employs three modules for query understanding, entity retrieval, and generation to improve SQL generation accuracy. |
| Outcome: | The proposed pipeline improves the accuracy of query generation on BIRD and Spider datasets. |
DSQG-Syn: Synthesizing High-quality Data for Text-to-SQL Parsing by Domain Specific Question Generation (2025.findings-naacl)
Copied to clipboard
Shaoming Duan, Youxuan Wu, Chuanyi Liu, Yuhao Zhang, Zirui Wang, Peiyi Han, Shengyuan Yu, Liang Yan, Yingwei Liang
| Challenge: | Existing methods for generating SQL queries using natural language questions produce inconsistent NLQ-SQL pairs. |
| Approach: | They propose a text-to-SQL data synthesis framework that generates domain-relevant questions . they synthesize NLQ-SqL pairs that are domain-specific and intent-consistent . |
| Outcome: | The proposed method outperforms closed-source LLMs on the Text-to-SQL task. |
Evaluating NL2SQL via SQL2NL (2025.findings-emnlp)
Copied to clipboard
| Challenge: | Existing benchmarks do not address robustness to linguistic variation in NL2SQL models . |
| Approach: | They propose a schema-aligned paraphrasing framework that leverages SQL-to-NL to generate semantically equivalent, lexically diverse queries while maintaining alignment with the original schema and intent. |
| Outcome: | The proposed framework generates semantically equivalent, lexically diverse queries while maintaining alignment with the original schema and intent. |
SPARQLing Database Queries from Intermediate Question Decompositions (2021.emnlp-main)
Copied to clipboard
| Challenge: | Using annotated datasets is difficult as it requires query-language expertise. |
| Approach: | They propose a crowdsourcing pipeline to annotate natural language questions using intermediate question representations. |
| Outcome: | The proposed pipeline reduces the burden of annotating a large dataset with queries by using intermediate question representations. |
Conversing with databases: Practical Natural Language Querying (2023.emnlp-industry)
Copied to clipboard
| Challenge: | Large amount of companies' data is stored in relational databases . quick hypotheses validation is rarely, if ever, possible for majority of nontechnical business stakeholders. |
| Approach: | They propose a hybrid NLQ system for conversational DB querying that allows non-technical users to formulate data requests as natural language questions. |
| Outcome: | The proposed system is based on a hybrid NLQ (Natural Language Querying) system for conversational DB querying. |
Recent Advances in Text-to-SQL: A Survey of What We Have and What We Expect (2022.coling-1)
Copied to clipboard
| Challenge: | text-to-SQL is a language processing and database-based language processing (NLP) task is to convert natural utterances into SQL queries and its practical application is to build natural language interfaces to database systems. |
| Approach: | They propose to conduct a systematic survey of text-to-SQL to examine the challenges and potential future directions. |
| Outcome: | The proposed system converts natural utterances into SQL queries and is a representative task in semantic parsing. |
Gen-SQL: Efficient Text-to-SQL By Bridging Natural Language Question And Database Schema With Pseudo-Schema (2025.coling-main)
Copied to clipboard
| Challenge: | Recent studies have shifted paradigms and leveraged Large Language Models (LLMs) to tackle the challenging task of Text-to-SQL. |
| Approach: | They propose a framework that leverages large language models to generate SQL queries . they exploit prior knowledge from the LLM to enhance embedding-based retriever . |
| Outcome: | The proposed method improves embedding-based retriever and reduces cost. |