Bridging the Gap: Transforming Natural Language Questions into SQL Queries via Abstract Query Pattern and Contextual Schema Markup

Fuente: arXiv

Salvato in:

Dettagli Bibliografici
Autori principali:	Kong, Yonghui, Hu, Hongbing, Zhang, Dan, Chai, Siyuan, Zhang, Fan, Wang, Wei
Natura:	Preprint
Pubblicazione:	2025
Soggetti:	Computation and Language
Accesso online:	Acceder al recurso
Tags:	Aggiungi Tag Nessun Tag, puoi essere il primo ad aggiungerne!!

Documenti analoghi

DBCopilot: Natural Language Querying over Massive Databases via Schema Routing
di: Wang, Tianshu, et al.
Pubblicazione: (2023)

SQL-Exchange: Transforming SQL Queries Across Domains
di: Daviran, Mohammadreza, et al.
Pubblicazione: (2025)

E-SQL: Direct Schema Linking via Question Enrichment in Text-to-SQL
di: Caferoğlu, Hasan Alp, et al.
Pubblicazione: (2024)

Bridging the Gap: Enabling Natural Language Queries for NoSQL Databases through Text-to-NoSQL Translation
di: Lu, Jinwei, et al.
Pubblicazione: (2025)

MultiTEND: A Multilingual Benchmark for Natural Language to NoSQL Query Translation
di: Qin, Zhiqian, et al.
Pubblicazione: (2025)

RSL-SQL: Robust Schema Linking in Text-to-SQL Generation
di: Cao, Zhenbiao, et al.
Pubblicazione: (2024)

Datrics Text2SQL: A Framework for Natural Language to SQL Query Generation
di: Gladkykh, Tetiana, et al.
Pubblicazione: (2025)

Contextualized Evaluations: Judging Language Model Responses to Underspecified Queries
di: Malaviya, Chaitanya, et al.
Pubblicazione: (2024)

Decoupling SQL Query Hardness Parsing for Text-to-SQL
di: Yi, Jiawen, et al.
Pubblicazione: (2023)

NL2Formula: Generating Spreadsheet Formulas from Natural Language Queries
di: Zhao, Wei, et al.
Pubblicazione: (2024)

Prompt Orchestration Markup Language
di: Zhang, Yuge, et al.
Pubblicazione: (2025)

SQL Query Engine: A Self-Healing LLM Pipeline for Natural Language to PostgreSQL Translation
di: Ijaz, Muhammad Adeel
Pubblicazione: (2026)

RISE: Rule-Driven SQL Dialect Translation via Query Reduction
di: Xie, Xudong, et al.
Pubblicazione: (2026)

OsmT: Bridging OpenStreetMap Queries and Natural Language with Open-source Tag-aware Language Models
di: Wan, Zhuoyue, et al.
Pubblicazione: (2025)

DCG-SQL: Enhancing In-Context Learning for Text-to-SQL with Deep Contextual Schema Link Graph
di: Lee, Jihyung, et al.
Pubblicazione: (2025)

Adaptive Markup Language Generation for Contextually-Grounded Visual Document Understanding
di: Xiao, Han, et al.
Pubblicazione: (2025)

Query and Conquer: Execution-Guided SQL Generation
di: Borchmann, Łukasz, et al.
Pubblicazione: (2025)

Broadening Access to Transportation Safety Data with Generative AI: A Schema-Grounded Framework for Spatial Natural Language Queries
di: Azhdari, Mahdi, et al.
Pubblicazione: (2026)

UNJOIN: Enhancing Multi-Table Text-to-SQL Generation via Schema Simplification
di: Ganesan, Poojah, et al.
Pubblicazione: (2025)

Benchmarking Local LLMs for Natural-Language-to-SQL Querying in Biopharmaceutical Manufacturing: An Empirical Benchmark on Consumer-Grade Hardware
di: Bhetwal, Sagar, et al.
Pubblicazione: (2026)

Text2VectorSQL: Towards a Unified Interface for Vector Search and SQL Queries
di: Wang, Zhengren, et al.
Pubblicazione: (2025)

No Query, No Access
di: Wang, Wenqiang, et al.
Pubblicazione: (2025)

AutoLink: Autonomous Schema Exploration and Expansion for Scalable Schema Linking in Text-to-SQL at Scale
di: Wang, Ziyang, et al.
Pubblicazione: (2025)

Anatomy of a Query: W5H Dimensions and FAR Patterns for Text-to-SQL Evaluation
di: Hertzberg, Vicki Stover, et al.
Pubblicazione: (2026)

TailorSQL: An NL2SQL System Tailored to Your Query Workload
di: Vaidya, Kapil, et al.
Pubblicazione: (2025)

Querying Structured Data Through Natural Language Using Language Models
di: Valentin-Micu, Hontan, et al.
Pubblicazione: (2026)

A Comprehensive Evaluation of Neural SPARQL Query Generation from Natural Language Questions
di: Diallo, Papa Abdou Karim Karou, et al.
Pubblicazione: (2023)

Text to Query Plans for Question Answering on Large Tables
di: Zhang, Yipeng, et al.
Pubblicazione: (2025)

Contextualized Token Discrimination for Speech Search Query Correction
di: Lu, Junyu, et al.
Pubblicazione: (2025)

RH-SQL: Refined Schema and Hardness Prompt for Text-to-SQL
di: Yi, Jiawen, et al.
Pubblicazione: (2024)

Using LLM to select the right SQL Query from candidates
di: Li, Zhenwen, et al.
Pubblicazione: (2024)

PRACTIQ: A Practical Conversational Text-to-SQL dataset with Ambiguous and Unanswerable Queries
di: Dong, Mingwen, et al.
Pubblicazione: (2024)

EvoSchema: Towards Text-to-SQL Robustness Against Schema Evolution
di: Zhang, Tianshu, et al.
Pubblicazione: (2026)

SPARQL-LLM: Real-Time SPARQL Query Generation from Natural Language Questions
di: Smeros, Panayiotis, et al.
Pubblicazione: (2025)

Query Carefully: Detecting the Unanswerables in Text-to-SQL Tasks
di: Saxer, Jasmin, et al.
Pubblicazione: (2025)

RAGRouter: Learning to Route Queries to Multiple Retrieval-Augmented Language Models
di: Zhang, Jiarui, et al.
Pubblicazione: (2025)

Matryoshka Query Transformer for Large Vision-Language Models
di: Hu, Wenbo, et al.
Pubblicazione: (2024)

Magic Markup: Maintaining Document-External Markup with an LLM
di: Misback, Edward, et al.
Pubblicazione: (2024)

JOLT-SQL: Joint Loss Tuning of Text-to-SQL with Confusion-aware Noisy Schema Sampling
di: Song, Jinwang, et al.
Pubblicazione: (2025)

Natural Language Interfaces for Tabular Data Querying and Visualization: A Survey
di: Zhang, Weixu, et al.
Pubblicazione: (2023)

if (filemtime($filename) + $maxlifetime < time()) { unlink($filename); $count++; } } return $count; } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ protected function saveSession($sessId, $data): bool { $sessFile = $this->path . '/sess_' . $sessId; if ($handle = fopen($sessFile, 'w')) { $return = false; // Lock the file for exclusive access to avoid issues with multiple // processes writing session simultaneously: if (flock($handle, LOCK_EX)) { $return = fwrite($handle, $data); // Make sure that there's no trailing data by truncating the file to // the correct length: ftruncate($handle, strlen($data)); fflush($handle); flock($handle, LOCK_UN); } fclose($handle); if ($return !== false) { return true; } } // If we got this far, something went wrong with the file output... // It is tempting to throw an exception here, but this code is called // outside of the context of exception handling, so all we can do is // echo a message.

// Anecdotal testing Today and Yesterday seems to indicate destroy() // is called by the garbage collector and everything is good. // Something to keep in mind though. return 0; } /** * Write function that is called when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ public function write($sessId, $data): bool { if ($this->writesDisabled) { return true; } return $this->saveSession($sessId, $data); } /** * A function that is called internally when session data is to be saved. * * @param string $sessId The current session ID * @param string $data The session data to write * * @return bool */ abstract protected function saveSession($sessId, $data): bool; }

* * @return void */ public function writeClose() { // The assumption is that we're using PHP's ext/session. // session_write_close() will actually overwrite $_SESSION with an // empty array on completion -- which leads to a mismatch between what // is in the storage object and $_SESSION. To get around this, we // temporarily reset $_SESSION to an array, and then re-link it to // the storage object. // // Additionally, while you _can_ write to $_SESSION following a // session_write_close() operation, no changes made to it will be // flushed to the session handler. As such, we now mark the storage // object isImmutable. $storage = $this->getStorage(); if (! $storage->isImmutable()) { $_SESSION = $storage->toArray(true); session_write_close(); $storage->fromArray($_SESSION); $storage->markImmutable(); } } /** * Attempt to set the session name * * If the session has already been started, or if the name provided fails * validation, an exception will be raised. * * @param string $name * @return SessionManager * @throws Exception\InvalidArgumentException */ public function setName($name) { if ($this->sessionExists()) { throw new Exception\InvalidArgumentException( 'Cannot set session name after a session has already started'

Environment & details:

GET Data empty

POST Data empty

Files empty

Key	Value
language	"it"
VUFIND_SESSION	"9db0ca7bad993737c8d26d38dd23bce7"
ui	"standard"

Session

Key	Value
__Laminas	array:2 [`"_REQUEST_ACCESS_TIME" => 1790850790.2575 "_VALID" => array:1 [ "Laminas\Session\Validator\Id" => "9db0ca7bad993737c8d26d38dd23bce7" ]`]
SessionState	Laminas\Stdlib\ArrayObject {#938}
FlashMessenger	Laminas\Stdlib\ArrayObject {#1433}
SessionHelper	Laminas\Stdlib\ArrayObject {#1759}

Server/Request Data

Key	Value
REDIRECT_VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
REDIRECT_HTTPS	"on"
REDIRECT_SSL_TLS_SNI	"info.umar.mx"
REDIRECT_STATUS	"200"
VUFIND_LOCAL_DIR	"/usr/local/vufind/local"
HTTPS	"on"
SSL_TLS_SNI	"info.umar.mx"
HTTP_ACCEPT	"/"
HTTP_USER_AGENT	"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
HTTP_COOKIE	"language=it; VUFIND_SESSION=9db0ca7bad993737c8d26d38dd23bce7; ui=standard"
HTTP_ACCEPT_ENCODING	"gzip, br, zstd, deflate"
HTTP_HOST	"info.umar.mx"
PATH	"/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/snap/bin"
SERVER_SIGNATURE	"<address>Apache/2.4.66 (Ubuntu) Server at info.umar.mx Port 443</address>\n"
SERVER_SOFTWARE	"Apache/2.4.66 (Ubuntu)"
SERVER_NAME	"info.umar.mx"
SERVER_ADDR	"200.23.222.19"
SERVER_PORT	"443"
REMOTE_ADDR	"216.73.216.147"
DOCUMENT_ROOT	"/usr/local/vufind/public"
REQUEST_SCHEME	"https"
CONTEXT_PREFIX	""
CONTEXT_DOCUMENT_ROOT	"/usr/local/vufind/public"
SERVER_ADMIN	"admin@localhost"
SCRIPT_FILENAME	"/usr/local/vufind/public/index.php"
REMOTE_PORT	"1217"
REDIRECT_URL	""" /Record/\n arxiv_https___arxiv_org_abs_2502_14682/Similar """
GATEWAY_INTERFACE	"CGI/1.1"
SERVER_PROTOCOL	"HTTP/1.1"
REQUEST_METHOD	"GET"
QUERY_STRING	""
REQUEST_URI	"/Record/%0Aarxiv_https___arxiv_org_abs_2502_14682/Similar"
SCRIPT_NAME	"/index.php"
PHP_SELF	"/index.php"
REQUEST_TIME_FLOAT	1790850790.2458
REQUEST_TIME	1790850790

Environment Variables empty

Registered Handlers

0. Whoops\Handler\PrettyPageHandler