Improving Text-to-SQL with a Hybrid Decoding Method [PDF]
Entropy, 2023 Text-to-SQL is a task that converts natural language questions into SQL queries. Recent text-to-SQL models employ two decoding methods: sketch-based and generation-based, but each has its own shortcomings.
Geunyeong Jeong +6 more
doaj +4 more sources
Towards Text-to-SQL over Aggregate Tables [PDF]
Data Intelligence, 2022 ABSTRACT Text-to-SQL aims at translating textual questions into the corresponding SQL queries. Aggregate tables are widely created for high-frequent queries. Although text-to-SQL has emerged as an important task, recent studies paid little attention to the task over aggregate tables.
Shuqin Li +4 more
openalex +2 more sources
Redefining text-to-SQL metrics by incorporating semantic and structural similarity [PDF]
Scientific ReportsThe rapid advancements in text-to-SQL systems have driven the scientific community to create increasingly complex benchmarks for this task. However, evaluation metrics often rely on simplistic or binary approaches that fail to capture the similarities ...
Giovanni Pinna +4 more
doaj +2 more sources
MedT5SQL: a transformers-based large language model for text-to-SQL conversion in the healthcare domain [PDF]
Frontiers in Big DataIntroductionIn response to the increasing prevalence of electronic medical records (EMRs) stored in databases, healthcare staff are encountering difficulties retrieving these records due to their limited technical expertise in database operations.
Alaa Marshan +5 more
doaj +2 more sources
SEOSS-Queries - a software engineering dataset for text-to-SQL and question answering tasks [PDF]
Data in Brief, 2022 Stakeholders of software development projects have various information needs for making rational decisions during their daily work. Satisfying these needs requires substantial knowledge of where and how the relevant information is stored and consumes ...
Mihaela Todorova Tomova +2 more
doaj +2 more sources
A case study using sewage metagenomic data for assessment of text-to-SQL capabilities in large language models [PDF]
Scientific ReportsRelational databases offer an efficient solution for storing and retrieving complex data sets, yet the requirement for SQL programming expertise presents a significant challenge for many life science users.
Ágnes Becsei +6 more
doaj +2 more sources
Retrieval-augmented Chinese text-to-SQL generation for conversational bibliographic search. [PDF]
PLoS ONETo overcome the limitations of current bibliographic search systems, such as low semantic precision and inadequate handling of complex queries, this study introduces a novel conversational search framework for the Chinese bibliographic domain.
Zhenyu Wang +3 more
doaj +3 more sources
Hierarchical Schema Representation for Text-to-SQL Parsing With Decomposing Decoding [PDF]
IEEE Access, 2019 Most of existing studies on parsing natural language (NL) for constructing structured query language (SQL) do not consider the complex structure of database schema and the gap between NL and SQL query.
Meina Song, Zecheng Zhan, Haihong E.
doaj +2 more sources
Advancing Conversational Text-to-SQL: Context Strategies and Model Integration with Large Language Models [PDF]
Future InternetConversational text-to-SQL extends the traditional single-turn SQL generation paradigm to multi-turn, dialogue-based scenarios, enabling users to pose and refine database queries interactively, and requiring models to track dialogue context over multiple
Benjamin G. Ascoli, Jinho D. Choi
doaj +2 more sources
ExSPIN: Explicit Feedback-Based Self-Play Fine-Tuning for Text-to-SQL Parsing [PDF]
EntropyRecently, self-play fine-tuning (SPIN) has garnered widespread attention as it enables large language models (LLMs) to iteratively enhance their capabilities through simulated interactions with themselves, transforming a weak LLM into a strong one ...
Liang Yan +7 more
doaj +2 more sources