ConceptioArchivearXiv CS
arXiv CSopen access

ODUTQA-MDC: A Task for Open-Domain Underspecified Tabular QA with Multi-turn Dialogue-based Clarification

Unknown · 2026 · arxiv_cs
arXiv CS · Papers · License: Open Access · 2026
Open Source ↗Direct PDF ↓
databasesdatamanagementsqlstorage
databases, sql, data management, storage

ODUTQA-MDC: A Task for Open-Domain Underspecified Tabular QA with Multi-turn Dialogue-based Clarification Zhensheng Wang1,2 , Zhanteng Lin3 , Wenmian Yang2,† , Kun Zhou1,2 , Yiquan Zhang2 , Weijia Jia2,4 1 School of Artificial Intelligence, Beijing Normal University, Beijing, PR China 2 Institute of Artificial Intelligence and Future Networks, Beijing Normal University, Zhuhai, PR China 3 Faculty of Arts and Sciences, Beijing Normal University, Zhuhai, PR China 4 Beijing Normal-Hong Kong Baptist University, Zhuhai, PR China {jensenwang, zhantenglin, zhoukun}@mail.bnu.edu.cn, {wenmianyang, jiawj}@bnu.edu.cn, [email protected]

arXiv:2604.10159v2 [cs.CL] 18 Apr 2026

Abstract The advancement of large language models (LLMs) has enhanced tabular question answering (Tabular QA), yet they struggle with opendomain queries exhibiting underspecified or uncertain expressions. To address this, we introduce the ODUTQA-MDC task and the first comprehensive benchmark to tackle it. This benchmark includes: (1) a large-scale ODUTQA dataset with 209 tables and 25,105 QA pairs; (2) a fine-grained labeling scheme for detailed evaluation; and (3) a dynamic clarification interface that simulates user feedback for interactive assessment. We also propose MAIC-TQA, a multi-agent framework that excels at detecting ambiguities, clarifying them through dialogue, and refining answers. Experiments validate our benchmark and framework, establishing them as a key resource for advancing conversational, underspecification-aware Tabular QA research. The data and code are available at https://github.com/jensenw1/ ODUTQA-MDC.

1

Introduction

Large language models (LLMs) have driven significant progress in open-domain tabular question answering (Tabular QA). Distinct from closeddomain settings where the target table is predetermined, the open-domain paradigm necessitates autonomously retrieving relevant tables from a largescale database (Fang et al., 2024; Kong et al., 2024; Rai et al., 2023). However, existing text-to-SQL approaches often falter when applied to this pipeline, as real-world user queries are frequently underspecified due to spelling errors, unclear expressions, or incomplete information. Such ambiguity fundamentally hinders the generation of correct SQL queries, leading to inaccurate answers. Existing research on this problem, while valuable, often remain limited to closed-domain scenarios that focus merely on detecting and classifying †

Corresponding author.

Q1: What is the greenery rate of the Vanke Light of the Future community in Bao'an District, Shenzhen?

SELECT FROM WHERE

Q2: How is the environment of the Vanke Light of the Future community in Bao'an District, Shenzhen?

SELECT FROM WHERE

Q3: What is the greenery rate of the Vanke Light of the Future community? Q4: What is the greenery rate of the Vanke community in Bao'an District, Shenzhen?

SELECT FROM WHERE

SELECT FROM WHERE

Figure 1: Examples of underspecified input causing questions to be unanswerable.

underspecifications (Bhaskar et al., 2023). These approaches do not resolve the core challenge: generating correct answers without user clarification. Even conversational datasets like PRACTIQ (Dong et al., 2025) rely on predetermined, static dialogues, failing to capture the dynamic and unpredictable nature of real-world user interactions. Real-world open-domain Tabular QA presents several core challenges that current methods do not address: autonomously selecting relevant tables from large databases, handling queries with multiple types of underspecification simultaneously, and generating accurate answers by integrating information gathered over users’ multi-turn clarification dialogues (Liu et al., 2025; Qin et al., 2026; Ye et al., 2025). Progress has been limited by the absence of suitable datasets and evaluation frameworks designed for these complexities. To address these gaps, we introduce ODUTQAMDC, a new task for Open-Domain Underspecified Tabular Question Answering with Multi-turn Dialogue-based Clarification. The task is supported by three components: a large-scale dataset, a finegrained labeling scheme, and a simulated clarification interface. We construct ODUTQA, the first dedicated open-domain underspecified Tabular QA dataset, with 209 structured tables and 25,105 QA pairs from property, real estate finance, and land

auction domains. To align with text-to-SQL workflows, we categorize underspecifications by their correspondence with SQL structures: table-scope underspecification (impacting the FROM clause; see Figure 1-Q3), query-intent underspecification (affecting the SELECT clause; see Figure 1-Q2), query-condition underspecification (affecting the WHERE clause; see Figure 1-Q4), and mixed underspecification. For a nuanced evaluation, our framework introduces fine-grained underspecification detection labels. Building on intent and slot labels from spoken language understanding, following previous work (Wang et al., 2025), we define three auxiliary detection labels: intent underspecification (identified via binary classification), scope underspecification, and condition underspecification (both using triplebased annotations for content, category, and error type). To simulate practical interactions, we integrate a conversational agent that dynamically generates clarification based only on the underspecifications detected by the system. This establishes a dynamic “detection-clarification-redetection” closedloop evaluation process, realistically simulating multi-turn interactions and enabling a rigorous assessment of a system’s ability to handle ambiguity. Building on this task, dataset, and evaluation framework, we introduce MAIC-TQA, an LLM-powered Multi-Agent Interactive Clarification framework for ODUTQA-MDC. MAIC-TQA comprises four collaborative agents: the Spoken Language Understanding (SLU) module, Scope Validator Agent, Table Retrieval Agent, and SQL Generation and Validation Agent. Working in concert, these agents deliver end-to-end, dynamic tabular QA with multi-turn clarification. The framework leverages external SQL tools and integrates execution feedback, such as SQL errors and empty results, to drive effective underspecification detection, adaptive clarification, and robust reasoning. Throughout the workflow, the system dynamically solicits clarifications, incorporates user responses, and iteratively refines both understanding and retrieval. By jointly optimizing underspecification identification and QA accuracy, MAIC-TQA establishes the first comprehensive agent-based benchmark for open-domain underspecified tabular QA with interactive, multi-turn dialogue. The main contributions of this paper are as follows: • We introduce the novel task of Open-Domain

Underspecified Tabular QA with Multi-turn Dialogue-based Clarification, supported by the first corresponding dataset (ODUTQA), detailed detection labels, and a dynamic conversational clarification interface. • We propose an agent-based open-domain Tabular QA system capable of effectively identifying and dynamically clarifying underspecifications through intelligent multi-turn interactions, substantially enhancing system adaptability in complex scenarios. • We systematically evaluate mainstream LLMs’ underspecification detection and QA performance on our dataset, presenting the first benchmark that comprehensively assesses the entire “information detection–multi-turn clarification–QA reasoning" workflow, facilitating further development in this research area.

2

Related Works

2.1

TQA Datasets

Mainstream Text-to-SQL datasets, such as Spider (Yu et al., 2018), WikiSQL (Zhong et al., 2017), and Open-WikiTable (Kweon et al., 2023), rarely consider underspecification in user queries. RETQA (Wang et al., 2025) provides SLU annotations but does not address underspecification. More recent datasets introduce underspecification via schema modification (Bhaskar et al., 2023), multi-turn dialogue (Dong et al., 2025), or human annotation (Saparina and Lapata, 2024). However, these datasets remain simplistic, lack systematic clarification annotation, and do not capture complex real-world mismatches between queries and database schemas. A detailed comparison of the datasets is provided in Table 1. 2.2

TQA Methods

Existing methods address open-domain TQA and underspecification separately. SLUTQA (Wang et al., 2025) enhances LLMs with intent-based example selection but does not resolve underspecification. PURPLE (Ren et al., 2024) prunes schema using a Steiner Tree approach, while LogicalBeam (Bhaskar et al., 2023) generates diverse SQL templates, though both have limited flexibility and coverage. Most importantly, current TQA methods lack error identification and dynamic conversational clarification, limiting their effectiveness in real-world underspecified scenarios.

Dataset

Open Domain

Underspecification

Spider RETQA PRACTIQ AmbiQT Ambrosia ODUTQA

% ! % ! ! !

% % ! ! ! !

Mixed Underspecification % % % % % !

QA Evaluation

Conversational

! ! % ! % !

% % ! % % !

Dynamic Clarification % % % % % !

Table 1: Dataset comparison. “Open Domain” indicates table retrieval from a large corpus, whereas “Closed Domain” (marked with ‘%’) specifies QA on given tables.

3

Task Construction and Analysis

3.1

Task Definition

The ODUTQA-MDC task evaluates open-domain tabular QA systems on their ability to resolve query ambiguities via multi-turn clarification. Given a user query and a multi-table database, the task consists of two stages: • Underspecification Detection: Identifying the specific ambiguity type within the query (i.e., SELECT, FROM, WHERE, or Mixed). • Clarification-based Dynamic QA: Interacting with a user simulator to resolve detected ambiguities, followed by standard Table Retrieval and SQL Generation to derive the final answer. 3.2

Datasets Construction

3.2.1 Data Source Our dataset originates from RETQA (Wang et al., 2025), a specified, open-domain QA dataset with 90 question templates, covering the Land Auction, Property, and Real Estate Finance domains. To support the four defined underspecification types (table-scope, query-intent, query-condition, and mixed), the original tables are normalized. Property and Land Auction tables are reorganized by city into 102 tables (avg. 1,040.37 rows) and 103 tables (avg. 30.35 rows), respectively. The four finance tables are consolidated by year (2019–2022), each averaging 444.75 rows. All resulting tables are stored in a PostgreSQL database (Stonebraker et al., 2019) to simulate realistic tabular QA scenarios. 3.2.2

Template Design and QA Pair Generation To construct a dataset of underspecified queries, we adapt 90 seed templates from RETQA, each associating a natural language question with a corresponding SQL query. Rather than altering the database

schema, our core strategy injects underspecification by manipulating the question templates and their assigned values. We begin with a detailed manual analysis, mapping each template variable to its SQL clause counterpart. This process connects variables to table captions (affecting the FROM clause), column headers (impacting the SELECT clause and defining user intent), and query conditions (appearing in the WHERE clause). This mapping informs two distinct strategies for introducing underspecification. The first, template restructuring, modifies the templates themselves to induce SELECT clause underspecification and create the Missing type for the FROM clause. The second, value modification, alters values in generated QA pairs to create WHERE clause underspecification and to produce the Unmatch and Error types for the FROM clause. These strategies yield three distinct categories of underspecification. • SELECT Underspecification Generation: This arises from an insufficiently specified user intent, making it difficult to identify the target column. To induce this, we replace explicit column references in templates with vague expressions. For instance, "green coverage ratio" is reformulated as “how is the environment?”, while a question regarding “risk level” is modified to “how is the business status?”. All original headers are preserved in a SELECT-Clarification dictionary for subsequent resolution. • FROM Underspecification Generation: This results from missing or incorrect scopedefining information, hindering table identification. It is introduced two ways. Missingtype underspecification is generated at the template level by omitting variables such as “city” or “district”. Error-type (typos) and

Unmatch-type (logical conflicts, e.g., a nonexistent city-district pair) are introduced by modifying values post-generation. All original, correct information is recorded in a FROM-Clarification dictionary. • WHERE Underspecification Generation: This occurs when incomplete or erroneous conditions hinder accurate data matching. We simulate this by post-processing QA pairs, replacing lengthy proper nouns (e.g., project names) with natural abbreviations from a fewshot prompted LLM. After creating a nameto-abbreviation map, we systematically replace the proper nouns in the questions. All original full names are stored in a WHEREClarification dictionary for downstream use. From the initial 90 templates, we identify 76 that are suitable for underspecification injection. These are systematically expanded into 222 extended templates, each incorporating diverse underspecification patterns in the SELECT and FROM clauses. Throughout this process, the corresponding target SQL template remains unchanged, as it represents the definitive query intent once underspecification is resolved. To ensure data quality, we sample two QA pairs per template for rigorous manual review against criteria of fluency, consistency, underspecification preservation, and annotation correctness. Templates are iteratively revised until they meet these standards. In the generation stage, validated templates are populated with sampled database entities, yielding 63,496 initial QA pairs. We then perform stratified sampling using the 76 template groups as strata, since templates naturally define distinct query structures and underspecification patterns and therefore provide an appropriate unit for controlling data balance. During this process, we further apply quality-control filters before and after SQL execution to remove cases that are unsuitable for an answerable QA benchmark. We then sample according to per-group target counts to achieve a balanced distribution across well-specified, single-underspecified, and mixedunderspecified examples. This procedure produces a final dataset of 25,105 QA pairs, including 5,095 well-specified, 7,892 single-underspecified (‘SELECT’: 197; ‘FROM’: 3,274; ‘WHERE’: 4,421), and 12,118 mixed-underspecified instances. The

data is split 6:2:2 into training (14,973), validation (5,046), and test (5,086) sets (see Appendix A.7). To further enhance linguistic naturalness, we paraphrase questions with an LLM. Given our dataset’s focus on underspecification, we use prompt engineering to explicitly prohibit the LLM from using forbidden words, namely, column headers specified in the SELECT-Clarification dictionary, thus preventing underspecified expressions from being made explicit. See Appendix A.3 for details. 3.3

Label Annotation

To support fine-grained analysis and evaluation of underspecification, we design a unified annotation scheme comprising two main categories: labels for spoken language understanding (SLU) (Xing et al., 2025; Qin et al., 2025) and labels for underspecification detection. Specifically, following previous work (Wang et al., 2025), we employ a templatefilling approach to synthesize the dataset, where all corresponding annotations are automatically inferred during the generation process. More details of label generation are provided in Appendix A. 3.3.1 Intent and Slot Annotation For SLU, we annotate both intent and slot information for each question. Specifically, following previous work (Wang et al., 2025), each seed template is assigned one or more intent labels. In cases where underspecification is introduced through the SELECT clause, the intent is annotated as “Unknown” to reflect uncertainty in user intent. Slot annotation adopts the standard BIO (Begin, Inside, Outside) format. Variables within question templates are treated as slots, with their types defined by the corresponding variable names, while all other tokens are labeled as “O”. 3.3.2 Underspecification Type Annotation In addition to standard annotations, our dataset defines three auxiliary underspecification detection labels: intent underspecification, scope underspecification, and condition underspecification, as follows: • Intent Underspecification Label: This binary label indicates whether a query exhibits intent underspecification. It is assigned as “True” if the user intent is unclear (i.e., with “unknown” intent label ), and “False” if the user intent is clear (i.e., with specific intent labels).

• Scope Underspecification Label: This label employs a triple-based annotation format [“slot_content”, “slot_type”, “error_type”], capturing errors related to table scope. For example, if a query omits the required “City” slot, the label is [“”, “City”, “Missing”]. The possible values for “error_type” are as follows: – Missing: A required slot is absent from the query. – Error: The slot content cannot be found in the database. – Unmatch: The individual slot values are valid, but their combination does not exist in the database. These labels directly determine whether the correct database table can be identified and serve as explicit signals for triggering system clarification. • Condition Underspecification Label: This label addresses underspecifications in the WHERE clause, particularly cases where a provided entity name (such as a project or enterprise) does not exist in the database. In such instances, the system generates a triplet [“slot_content”, “slot_type”, “not exist”], for example, [“ABC Technology Inc.”, “enterprise name”, “not exist”]. This enables the system to explicitly identify invalid query conditions and initiate targeted clarification or correction. 3.4

Conversational Clarification Interface

To overcome the limitations of prior work that focuses on static underspecification classification, we introduce an automated interactive user simulator that resolves underspecified queries through multiturn clarification dialogues. This design choice addresses a critical practical constraint: while human interaction provides high realism, it is prohibitively expensive and lacks consistency and reproducibility at scale. Our simulator offers a scalable and standardized alternative that preserves sufficient linguistic realism for robust evaluation. The simulator is implemented as a callable Python interface for handling SELECT, FROM, and WHERE underspecification types. Clarification is strictly gated by detection accuracy: corrective information is provided only when the predicted underspecification label matches the ground

truth; otherwise, no clarification is revealed. Upon correct detection, the interface retrieves the corresponding ground-truth value from clarification dictionaries. This value is inserted into a standardized response template. To emulate natural user interactions, an LLM is employed to paraphrase these templates into colloquial expressions. To guarantee reliability, we implement a rigorous post-generation verification mechanism. Specifically, the system validates that the ground-truth value retrieved from the dictionary remains invariant within the paraphrased response. If the value is missing, the system regenerates the response; if regeneration fails after a fixed number of attempts, it falls back to the standardized template. This design ensures linguistic diversity without sacrificing factual accuracy. To support diverse benchmarking, the interface offers two modes: Dynamic Mode generates varied responses to assess robustness under realistic conditions, while Fixed Mode delivers standardized responses for reproducibility. See Appendix A.5 for implementation details and Appendix A.6 for the design rationale.

4

Method

4.1

Overview

As illustrated in Figure 2, the MAIC-TQA framework adopts a modular, multi-agent architecture to address open-domain underspecified tabular question answering with multi-turn clarification. The workflow proceeds as follows: First, the SLU Module (Section 4.2) extracts user intent and slot information from the natural language query. Next, the Scope Validator Agent (Section 4.3) verifies and, if necessary, requests clarification for caption-related slots to ensure accurate table scope identification. The Table Retrieval Agent (Section 4.4) then integrates the original query and user clarifications to determine the most relevant table caption. Finally, the SQL Generation and Validation Agent (Section 4.5) constructs and executes the SQL query, validating the output to generate the final answer (Duan et al., 2025). 4.2

SLU Module

Given a user’s natural language query, we first employ a BERT-based classifier (Devlin et al., 2019) for intent detection and slot filling (Qin et al., 2021; Cheng et al., 2023). An intent underspecification label is generated based on the classifier’s output.

Stage 1. SLU Module Query How is the environment of the Tomorrow City community in Nanjing?

Dialog

Stage 3. TR Agent

How is the environment of the Tomorrow City community in Nanjing?

Dialog

Agent

Your input is unclear, please clarify your request further.

Intent

Slots

Domain

I want to query the floor area ratio.

Stage 2. SV Agent

You did not provide the correct district name.

Table captions

Query

Domain

This community is located in Xuanwu District, Nanjing.

Slots Slot Types

Agent Tool [ “”, “District”, “Missing” ]

The community "Tomorrow City" could not be found, please confirm if the community name is correct. The community name should be Forte Tomorrow City. The floor area ratio of Forte Tomorrow City is 3.33.

Intent Candidate Prompts

BERT

You are a Scope Validator Agent. Please use the provided information to call tools for slot validation and classify the slots accordingly. (...)

Prompt

Summary

BM25 Related Tables

Table captions

Stage 4. SGV Agent Dialog Domain

Intent Candidate Prompts

Slots Related Tables ["Tomorrow City", project_name, "not exist"]

Prompt

Agent Tool Null

[ "Forte Tomorrow City", floor_area_ratio, 3.33 ]

Figure 2: General framework of MAIC-TQA.

If intent underspecification is detected, the system issues a template-based follow-up question (e.g., “Your input is unclear. Please clarify your request.”) to prompt user clarification. Upon receiving the user’s response, the system concatenates the original query with the clarification to form an updated conversational context, which is then reprocessed by the BERT classifier for a second attempt at intent recognition. Once a valid intent is identified, the system proceeds to slot validation. To maintain interaction efficiency, the clarification loop is restricted to a single iteration. For downstream processing, clarified intent labels are mapped to one of three domains, i.e., Property Sales, Land Auctions, or Enterprise Finance, as the domain labels for subsequent tasks. 4.3

Scope Validator Agent

The primary function of the Scope Validator Agent (SV Agent) is to verify the scope information in user queries, enabling accurate table matching. Scope information is typically represented by slot annotations; therefore, the agent receives the user’s original query, the domain label, the slot labels, and the list of domain-required slots as input. The validation process begins by checking for missing slots. The agent compares the extracted slots against the required slot types for the given domain. If a required slot is missing, the agent

immediately assigns a scope underspecification label with “Missing” as the error_type, following the specified prompt. For example, if the “District” slot is absent, the output triplet would be (“”, “District”, “Missing”), as shown in Figure 2. If all required slots are present, the agent proceeds to verify the validity of the provided slot values. This is accomplished by calling a validation function, which cross-references the input slot values with the corresponding database tables for the specified domain, based on a detailed prompt. If any slot value fails validation (e.g., the content does not exist or the slot combination is invalid), the agent generates the appropriate Scope Underspecification Label and prompts the user for clarification. This two-stage validation process ensures both the completeness and the correctness of scope information, facilitating robust and accurate table selection. The detailed prompt templates and validation functions used by this agent are provided in Appendix D. 4.4

Table Retrieval Agent

The Table Retrieval Agent (TR Agent) generates a concise summary of the target table based on the user’s original query and the supplementary information collected by the Scope Validator Agent. It analyzes the complete dialogue history, identifying

system prompts for clarification and corresponding user responses. According to the previously predicted intent label, the agent selects different representative examples as context for in-context learning. It then integrates information from both the initial query and the clarifications to produce a table summary, which serves as the predicted table caption. Table retrieval follows a two-stage process. First, the system attempts to find an exact match between the generated summary and the table captions in the database. If there is no exact match, the system performs a similarity search using the BM25 algorithm (Robertson and Zaragoza, 2009). If the agent cannot generate a summary due to insufficient dialogue information, the full dialogue history is used directly for BM25 retrieval. This approach ensures robust table retrieval in all cases. The detailed prompt templates used by this agent are provided in Appendix D.

4.5

SQL Generation and Validation Agent

After table retrieval, the SQL Generation and Validation Agent (SGV Agent) is responsible for generating and validating SQL queries. The agent takes four inputs: the complete dialogue history, the predicted domain, the extracted slots, and the related table captions. Guided by the user’s intent, the agent selects an appropriate prompt template containing five representative gold SQL examples for in-context learning, and then generates and executes the SQL query accordingly. If the query is successful and meets all user requirements, the system returns the final SQL query and result, completing the task. If the result is empty or incomplete (e.g., only a subset of the requested entities is returned), the agent calls a predefined SQL validation function to identify missing conditions, generates a condition underspecification label, and requests clarification from the user. This clarification is appended to the dialogue history to form an updated context for a single round of SQL regeneration. If the new query still fails or returns no results, the process ends, and the empty output is recorded as the final result. Details of the prompt templates and the SQL validation function are provided in Appendix D.

5

Experiments

5.1

Tasks and Baselines

We utilize ODUTQA-MDC as the benchmark for open-domain underspecified tabular question answering, which consists of two sub-tasks: (i) underspecification detection, including intent, scope, and condition detection, and (ii) clarification-based dynamic QA that evaluates a system’s ability to resolve underspecified queries through interaction. As this benchmark explicitly targets clarificationaware reasoning over incomplete user inputs, there are no directly comparable prior systems that jointly model underspecification detection and clarification-driven query execution in tabular settings. For comparative evaluation, we implement MAIC-TQA together with a state-of-the-art tabular QA framework, SLUTQA (Wang et al., 2025), which does not employ clarification and instead answers directly from underspecified queries, serving as a clarification-free baseline. For MAICTQA, we evaluate both fixed and dynamic clarification responses, where all dynamic responses are generated by Qwen2.5-72B for consistency. The SGV Agent is responsible for SQL generation and execution, taking the complete dialogue history, predicted domain, extracted slots, and table captions as input; guided by user intent, it selects a prompt template with five gold SQL examples for in-context learning and generates the executable query. We support both MAIC-TQA and SLUTQA using LLM backbones with function-calling capabilities, including open-source Qwen3 32B and Qwen3 30B (A3B)(Yang et al., 2025) deployed via SGLang(Zheng et al., 2024) with default chain-ofthought, and closed-source Kimi K2 (Team et al., 2025), GLM 4 (GLM et al., 2024), and Doubao (Seed 1.6 flash-250828) accessed through official APIs with default settings. Additional details are provided in Appendix B.2 and C. 5.2

Implementation

This section presents the evaluation metrics and implementation details for the two core tasks defined in Section 3.4: Underspecification Detection and Clarification-based Dynamic QA. Evaluation Metrics For the Underspecification Detection task, we adopt Accuracy and macro F1score to assess the model’s ability to detect intent, scope, and condition underspecifications. Accuracy is calculated on the entire dataset, while F1 is

Model BERT Qwen3 32B Qwen3 30B Kimi K2 GLM 4 Doubao

SELECT Acc. F1 99.78 99.22 – – – – – – – – – –

Fixed Clarification FROM WHERE Acc. F1 Acc. F1 – – – – 77.66 82.82 69.59 66.02 75.17 85.10 75.67 78.99 82.60 87.95 69.02 65.54 81.10 86.71 44.77 28.96 81.36 89.46 73.72 75.69

Mixed Acc. – 54.96 58.55 55.51 37.97 61.21

Dynamic Clarification FROM WHERE Acc. F1 Acc. F1 – – – – 78.78 85.11 73.81 72.49 69.95 77.45 72.49 69.50 81.63 87.31 64.81 59.55 78.55 84.39 57.02 53.41 81.22 89.23 83.59 84.38

Mixed Acc. – 59.42 52.92 52.69 46.23 68.50

Table 2: Overall performance of underspecification detection under fixed and dynamic clarification settings.

Model Qwen3 32B Qwen3 30B Kimi-K2 GLM 4 Doubao

Method SLUTQA Ours (Fix) Ours (Dyn) SLUTQA Ours (Fix) Ours (Dyn) SLUTQA Ours (Fix) Ours (Dyn) SLUTQA Ours (Fix) Ours (Dyn) SLUTQA Ours (Fix) Ours (Dyn)

Table Retrieval F1 60.07 92.89 93.48 58.78 95.10 91.17 62.33 95.07 97.13 60.15 89.89 89.28 59.95 77.40 93.43

SQL Generation ECR EA 85.90 24.20 97.46 57.44 98.13 57.89 86.75 21.22 96.32 54.11 97.56 49.55 88.35 30.70 98.26 63.89 98.39 59.86 85.51 25.75 85.88 32.47 88.84 44.63 78.52 23.72 90.81 41.54 97.56 53.23

Table 3: Table retrieval and SQL generation results (“Fix”/“Dyn”: Fixed/Dynamic clarification).

reported specifically for underspecified queries. For the Clarification-based Dynamic QA task, evaluation is divided into two sub-tasks: (1) Table Retrieval, evaluated using F1 score; and (2) SQL Generation, assessed by Execution Correctness Rate (ECR) and Execution Accuracy (EA) (Yu et al., 2018). ECR denotes the proportion of generated SQL statements that can be executed without error, while EA measures the proportion of cases where the execution result of the generated SQL exactly matches the gold standard result. For SLUTQA, BERT parameters are loaded directly from the officially released pre-trained model. For our method, BERT is fine-tuned on the ODUTQA training set. All LLM API calls follow their respective official default settings. Detailed performance of the SLU Module is provided in Appendix B.1. 5.3

Results and Discussions

In this section, we present the experimental results and analysis. The results of the ablation study are shown in Appendix B.3. For the underspecification detection task, we

evaluate model performance on three types corresponding to SQL clauses: intent (SELECT), scope (FROM), and condition (WHERE). As summarized in Table 2, the BERT-based approach achieves strong results in both Accuracy and F1 score for intent underspecification. For scope underspecification, Kimi-K2 achieves the highest accuracy in both dynamic and fixed scenarios, while Doubao Seed 1.6 achieves the highest F1 score in both scenarios. For condition underspecification, Qwen3 30B A3B achieves the highest accuracy and F1 score in the fixed scenario, whereas Doubao Seed 1.6 achieves the highest accuracy and F1 score in the dynamic scenario. The mixed underspecification task proves extremely challenging due to an error accumulation effect, where failing to detect a single problem type leads to an overall incorrect prediction. Despite this difficulty, Doubao Seed 1.6 achieves the highest accuracy for this task across both dynamic and fixed scenarios. In table retrieval, our method demonstrates robust performance across all models, as reported in Table 3. This gain is primarily attributed to our method’s ability to proactively identify missing key information, such as table captions, and to elicit necessary details via follow-up questions, resulting in more precise retrieval. For SQL generation, our method demonstrates superior performance on all models, as shown in Table 3. Specifically, on Doubao Seed 1.6, our method achieves execution compliance rate (ECR) improvements of 12.29% and 19.04% over SLUTQA in the fixed and dynamic scenarios, respectively. Furthermore, on the EA metric, which more accurately captures intent alignment, our method achieves substantial improvements of 33.24% and 33.69% on Qwen3 32B for the fixed and dynamic scenarios, respectively, which further underscores the necessity of clarification mechanisms for handling underspecified problems in table QA.

6

Conclusion

In this paper, we introduce ODUTQA-MDC, a new task for open-domain underspecified tabular question answering with multi-turn clarification. We provide three resources to support evaluation: ODUTQA, the first large-scale underspecified tabular QA dataset; a fine-grained underspecification labeling scheme; and a dynamic clarification interface. We further propose MAIC-TQA, an LLMbased agent framework that combines adaptive underspecification detection with iterative clarification. Extensive experiments benchmark diverse LLMs and baselines, delivering the first unified evaluation of underspecification detection, clarification, and end-to-end QA, and establishing foundational benchmarks for underspecification-aware tabular QA.

Limitations While our proposed framework offers significant advancements in handling underspecified user queries, we acknowledge specific boundaries in our experimental design regarding the scope of ambiguity, interaction modeling, and domain coverage. Regarding the dataset and SQL complexity, ODUTQA-MDC focuses strictly on informational underspecification within the SELECT, FROM, and WHERE clauses, intentionally excluding complex aggregations (e.g., GROUP BY or HAVING) and open-ended linguistic ambiguities. This scoping is a deliberate design choice to isolate and rigorously evaluate the model’s ability to perform logical clarification mapping without the confounding factors of linguistic noise or advanced compositional reasoning, which would obscure the core clarification mechanism in a controlled study. Concerning the evaluation paradigm, our user simulator prioritizes logical consistency and factuality over the full spectrum of human behavioral stochasticity, such as irrelevant chitchat or dynamic goal deviations. While this reduces the chaotic nature of real-world interactions, it is critical for establishing a reproducible benchmark. By minimizing interaction noise, we ensure that performance differences can be attributed solely to the model’s capacity to resolve logical ambiguities rather than its robustness to open-domain distractions, thus serving as a standardized framework for this specific capability. Finally, with respect to domain generalizability, our current experiments are centered on the

real estate market, a vertical characterized by dense attributes and user constraints. However, the proposed framework is designed to be schemaagnostic, with clarification logic grounded in universal SQL syntax rather than domain-specific rules. Therefore, despite the single-domain dataset, the underlying methodology for detecting and resolving underspecification remains methodologically generalizable to other vertical industries such as healthcare or e-commerce.

Acknowledgments This work is supported in part by the National Natural Science Foundation of China (NSFC) under Grant 62272050 and the grant of Beijing Normal- Hong Kong Baptist University sponsored by Guangdong Provincial Department of Education; in part by Zhuhai Science-Tech Innovation Bureau under Grant No. 2320004002772 and the Interdisciplinary Intelligence Super Computer Center of Beijing Normal University (Zhuhai).

References Adithya Bhaskar, Tushar Tomar, Ashutosh Sathe, and Sunita Sarawagi. 2023. Benchmarking and improving text-to-sql generation under ambiguity. In Proceedings of the 2023 Conference on Empirical Methods in Natural Language Processing, EMNLP 2023, Singapore, December 6-10, 2023, pages 7053–7074. Association for Computational Linguistics. Ziyang Chen, Jinzhi Liao, and Xiang Zhao. 2023. Multigranularity temporal question answering over knowledge graphs. In Proceedings of the 61st Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), ACL 2023, Toronto, Canada, July 9-14, 2023, pages 11378–11392. Association for Computational Linguistics. An-Chieh Cheng, Hongxu Yin, Yang Fu, Qiushan Guo, Ruihan Yang, Jan Kautz, Xiaolong Wang, and Sifei Liu. 2024. Spatialrgpt: Grounded spatial reasoning in vision-language models. In Advances in Neural Information Processing Systems 38: Annual Conference on Neural Information Processing Systems 2024, NeurIPS 2024, Vancouver, BC, Canada, December 10 - 15, 2024. Lizhi Cheng, Wenmian Yang, and Weijia Jia. 2023. A scope sensitive and result attentive model for multiintent spoken language understanding. In Proceedings of the AAAI Conference on Artificial Intelligence, pages 12691–12699. AAAI Press. Jacob Devlin, Ming-Wei Chang, Kenton Lee, and Kristina Toutanova. 2019. BERT: pre-training of deep bidirectional transformers for language understanding. In Proceedings of the 2019 Conference of

the North American Chapter of the Association for Computational Linguistics: Human Language Technologies, NAACL-HLT 2019, Minneapolis, MN, USA, June 2-7, 2019, Volume 1 (Long and Short Papers), pages 4171–4186. Association for Computational Linguistics. Mingwen Dong, Nischal Ashok Kumar, Yiqun Hu, Anuj Chauhan, Chung-Wei Hang, Shuaichen Chang, Lin Pan, Wuwei Lan, Henghui Zhu, Jiarong Jiang, Patrick Ng, and Zhiguo Wang. 2025. PRACTIQ: A practical conversational text-to-sql dataset with ambiguous and unanswerable queries. In Proceedings of the 2025 Conference of the Nations of the Americas Chapter of the Association for Computational Linguistics: Human Language Technologies, NAACL 2025 - Volume 1: Long Papers, Albuquerque, New Mexico, USA, April 29 - May 4, 2025, pages 255–273. Association for Computational Linguistics. Yifan Duan, Yihong Tang, Kehai Chen, Liqiang Nie, and Min Zhang. 2025. ORPP: Self-optimizing roleplaying prompts to enhance language model capabilities. In Proceedings of the 2025 Conference on Empirical Methods in Natural Language Processing, pages 28585–28600, Suzhou, China. Association for Computational Linguistics. Xi Fang, Weijie Xu, Fiona Anting Tan, Jiani Zhang, Ziqing Hu, Yanjun Qi, Scott Nickleach, Diego Socolinsky, Srinivasan H. Sengamedu, and Christos Faloutsos. 2024. Large language models(llms) on tabular data: Prediction, generation, and understanding - A survey. CoRR, abs/2402.17944. Team GLM, Aohan Zeng, Bin Xu, and Bowen Wang et al. 2024. Chatglm: A family of large language models from glm-130b to glm-4 all tools. Preprint, arXiv:2406.12793. Kezhi Kong, Jiani Zhang, Zhengyuan Shen, Balasubramaniam Srinivasan, Chuan Lei, Christos Faloutsos, Huzefa Rangwala, and George Karypis. 2024. Opentab: Advancing large language models as opendomain table reasoners. CoRR, abs/2402.14361. Sunjun Kweon, Yeonsu Kwon, Seonhee Cho, Yohan Jo, and Edward Choi. 2023. Open-wikitable : Dataset for open domain question answering with complex reasoning over table. In Findings of the Association for Computational Linguistics: ACL 2023, Toronto, Canada, July 9-14, 2023, pages 8285–8297. Association for Computational Linguistics. Zeming Liu, Haifeng Wang, Zeyang Lei, Zheng-Yu Niu, Hua Wu, and Wanxiang Che. 2025. Towards fewshot mixed-type dialogue generation. Sci. China Inf. Sci., 68(2). Libo Qin, Qiguang Chen, Xiachong Feng, Yang Wu, Yongheng Zhang, Yinghui Li, Min Li, Wanxiang Che, and Philip S. Yu. 2026. Large language models meet NLP: a survey. Frontiers Comput. Sci., 20(11):2011361.

Libo Qin, Qiguang Chen, Jingxuan Zhou, Jin Wang, Hao Fei, Wanxiang Che, and Min Li. 2025. Dividesolve-combine: An interpretable and accurate prompting framework for zero-shot multi-intent detection. In AAAI-25, Sponsored by the Association for the Advancement of Artificial Intelligence, February 25 - March 4, 2025, Philadelphia, PA, USA, pages 25038–25046. AAAI Press. Libo Qin, Tailu Liu, Wanxiang Che, Bingbing Kang, Sendong Zhao, and Ting Liu. 2021. A co-interactive transformer for joint slot filling and intent detection. In ICASSP 2021-2021 IEEE International Conference on Acoustics, Speech and Signal Processing (ICASSP), pages 8193–8197. IEEE. Daking Rai, Bailin Wang, Yilun Zhou, and Ziyu Yao. 2023. Improving generalization in language modelbased text-to-sql semantic parsing: Two simple semantic boundary-based techniques. In Proceedings of the 61st Annual Meeting of the Association for Computational Linguistics (Volume 2: Short Papers), ACL 2023, Toronto, Canada, July 9-14, 2023, pages 150–160. Association for Computational Linguistics. Tonghui Ren, Yuankai Fan, Zhenying He, Ren Huang, Jiaqi Dai, Can Huang, Yinan Jing, Kai Zhang, Yifan Yang, and X. Sean Wang. 2024. PURPLE: making a large language model a better SQL writer. In 40th IEEE International Conference on Data Engineering, ICDE 2024, Utrecht, The Netherlands, May 13-16, 2024, pages 15–28. IEEE. Stephen E. Robertson and Hugo Zaragoza. 2009. The probabilistic relevance framework: BM25 and beyond. Found. Trends Inf. Retr., 3(4):333–389. Irina Saparina and Mirella Lapata. 2024. AMBROSIA: A benchmark for parsing ambiguous questions into database queries. In Advances in Neural Information Processing Systems 38: Annual Conference on Neural Information Processing Systems 2024, NeurIPS 2024, Vancouver, BC, Canada, December 10 - 15, 2024. Michael Stonebraker, Lawrence A. Rowe, and Michael Hirohama. 2019. The implementation of POSTGRES. In Michael L. Brodie, editor, Making Databases Work: the Pragmatic Wisdom of Michael Stonebraker, volume 22 of ACM Books, pages 519– 559. ACM / Morgan & Claypool. Kimi Team, Yifan Bai, Yiping Bao, and et al. 2025. Kimi k2: Open agentic intelligence. Preprint, arXiv:2507.20534. Zhensheng Wang, Wenmian Yang, Kun Zhou, Yiquan Zhang, and Weijia Jia. 2025. RETQA: A large-scale open-domain tabular question answering dataset for real estate sector. In AAAI-25, Sponsored by the Association for the Advancement of Artificial Intelligence, February 25 - March 4, 2025, Philadelphia, PA, USA, pages 25452–25460. AAAI Press.

Bowen Xing, Libo Qin, Zhihong Zhu, Zhou Yu, and Ivor W Tsang. 2025. Dxa-net: Dual-task crosslingual alignment network for zero-shot cross-lingual spoken language understanding. IEEE Transactions on Pattern Analysis and Machine Intelligence. An Yang, Anfeng Li, Baosong Yang, and et al. 2025. Qwen3 technical report. CoRR, abs/2505.09388. Linhao Ye, Lang Yu, Zhikai Lei, Qin Chen, Jie Zhou, and Liang He. 2025. Optimizing question semantic space for dynamic retrieval-augmented multi-hop question answering. In Proceedings of the 63rd Annual Meeting of the Association for Computational Linguistics (Volume 1: Long Papers), ACL 2025, Vienna, Austria, July 27 - August 1, 2025, pages 17814– 17824. Association for Computational Linguistics. Tao Yu, Rui Zhang, Kai Yang, Michihiro Yasunaga, Dongxu Wang, Zifan Li, James Ma, Irene Li, Qingning Yao, Shanelle Roman, Zilin Zhang, and Dragomir R. Radev. 2018. Spider: A large-scale human-labeled dataset for complex and cross-domain semantic parsing and text-to-sql task. In Proceedings of the 2018 Conference on Empirical Methods in Natural Language Processing, Brussels, Belgium, October 31 - November 4, 2018, pages 3911–3921. Association for Computational Linguistics. Lianmin Zheng, Liangsheng Yin, Zhiqiang Xie, Chuyue Sun, Jeff Huang, Cody Hao Yu, Shiyi Cao, Christos Kozyrakis, Ion Stoica, Joseph E. Gonzalez, Clark W. Barrett, and Ying Sheng. 2024. Sglang: Efficient execution of structured language model programs. In Advances in Neural Information Processing Systems 38: Annual Conference on Neural Information Processing Systems 2024, NeurIPS 2024, Vancouver, BC, Canada, December 10 - 15, 2024. Victor Zhong, Caiming Xiong, and Richard Socher. 2017. Seq2sql: Generating structured queries from natural language using reinforcement learning. CoRR, abs/1709.00103.

A

Dataset Construction and Statistics

A.1

Template Filling

A.1.1 Implementation Details Based on 209 tables, we design 222 seed templates. As shown in Figure 3, these templates are categorized by underspecification type: 38 with SELECT underspecification, 113 with FROM underspecification, and 71 that are specified. Each seed template comprises four components: a Question Template, an SQL Template, a SELECT clarification, and a FROM clarification. The parts enclosed in “{}" are slots to be populated, and the slots across these four components are correspondingly linked. After randomly selecting appropriate values from the database, these values are used to populate the corresponding slots within the template. In the template’s components, the SELECT clarification is

Question Template: SQL Template:

请问{城市名称}的{项目名称}这个小区的环境如何? SELECT "项目名称","容积率" FROM "{城市名称}{区域名称}土地成交信息表" WHERE "项目名称" = '{项目名称}';

SELECT-Clarification 列名:容积率 FROM-Clarification

区域名称:{区域名称}

Question Template:

How is the environment of {Project_name} in {City_name}?

SQL Template:

SELECT "project_name","floor area ratio" FROM "Land Auction Table for {District_name}, {City_name}" WHERE "project_name" = '{Project_name}';

SELECT-Clarification Column_name: Floor Area Ratio FROM-Clarification

District_name:{District_name}

Figure 3: Examples of Template Filling (Chinese–English Bilingual).

stored in a dictionary format without any slots; its purpose is to record the definitive user’s final intent after an underspecified query is clarified. The FROM clarification contains slots related to the table caption, which are populated concurrently with other slots during the data sampling stage. Furthermore, the static text (i.e., the non-slot part) of a template determines its intent type and is uniformly labeled “O" during BIO tagging, whereas the slot parts are tagged according to their specific sampled values. Once all slots in a template are populated, the system executes the query generated from the SQL template, and the query result serves as the final answer to the corresponding question. An example of a complete generated QA pair is illustrated in Figure 5. A.1.2

Rationale for Template-based Construction

Template-based construction with controlled perturbations is standard practice in recent QA and TQA datasets, such as MULTITQ (Chen et al., 2023), RETQA (Wang et al., 2025), and SpatialRGPTBench (Cheng et al., 2024), etc. This approach ensures that the generated questions are logically consistent and answerable. Compared to manual annotation or crowdsourcing, which is prohibitively expensive and often suffers from inconsistent quality, template-based generation allows for high-volume, high-quality data creation that covers specific phenomena systematically. We acknowledge that pure templates could in principle reduce diversity; therefore, we deliberately decouple semantic patterns from surface forms. Specifically, templates are used to encode the SQL intent and the specific type of underspecification. The natural-language wording is then produced by a LLM that is prompted to

use varied, colloquial question styles while strictly preserving the intent and ambiguity constraints. Dictionaries are utilized only to sample realistic entities and attribute values from real tables (e.g., city names or financial indicators), not to constrain how questions are phrased. Combined with random sampling over templates, entities, and operators, this strategy yields a broad range of question types. The relatively low Text-to-SQL EA on MAIC-TQA (see Section 5.3) demonstrates that these questions, despite being synthesized, still present significant challenges to current state-of-the-art models. A.2

SLU Annotations in TQA

Figure 4 illustrates the application of Spoken Language Understanding (SLU) tags, which serve as a critical semantic bridge between unstructured natural language and structured SQL queries in our framework. The SLU annotations consist of two distinct components: Slots and Intents. 1. Slot Tags (BIO Annotation): We employ the BIO (Begin-Inside-Outside) tagging scheme to identify specific entities that act as filtering constraints in the SQL query. In the visual example, the tokens “Shanghai”, “July”, and “2022” are explicitly tagged as B-C (City), B-M (Month), and B-Y (Year), respectively. Among them, “Shanghai” serves as the table scope information (affecting the FROM clause), while “July” and “2022” map directly to the condition values in the SQL WHERE clause (e.g., WHERE Date = ‘2022-07’). 2. Intent Labels: Intents capture the semantic goal of the query, determining which columns and operations (such as sorting or aggregation) are required. The example demonstrates a composite intent scenario where the user asks for both volume ranking and price comparison. Consequently, the utterance is labeled with two intents. Role in TQA. In the Table Question Answering task, these SLU tags serve as critical intermediate signals for bridging natural language and structured queries. The Intent labels help the model identify the user’s query goal, enabling more effective in-context example retrieval for few-shot learning. The Slot tags, on the other hand, capture the key entities that constitute essential components of the SQL query, such as filtering conditions and target

columns. By explicitly decoupling entity extraction (Slots) from logic determination (Intents), the model can better understand user intent and generate SQL queries that are both syntactically correct and semantically aligned with the user’s request. A.3

LLM-based Query Rewriting

Template-generated queries often display rigid and monolithic syntactic patterns, which differ markedly from the more flexible and natural language used by real users. This mismatch can lead to suboptimal model performance when handling authentic user queries. To mitigate this issue, we leverage Large Language Models (LLMs)—specifically, the Qwen2.5-72B model—to rewrite template-generated queries. This rewriting process is designed to preserve the original semantics while introducing greater linguistic diversity through synonym replacement and syntactic structure adjustments, resulting in queries that better resemble human language. Building on this, we also adopt an augmentation strategy inspired by RETQA, in which questions are further paraphrased using an LLM to enhance linguistic naturalness. Given that our dataset targets underspecified scenarios, we take care to prevent the LLM from simplifying underspecified expressions into non-underspecified forms. To this end, we enforce additional constraints in the prompt, prohibiting the use of specific forbidden words—namely, column names defined in the SELECT-Clarification dictionary—to maintain the intended underspecification. Details of the prompt formulations used for these rewriting processes are provided in Appendix D, Figure 6. A.4

Quality Assessment of LLM-based Paraphrasing

To rigorously validate the quality of the LLM-based rewriting, we conducted a manual assessment on samples drawn exclusively from the test set. We excluded QA pairs without underspecification and randomly selected 200 QA pairs that contained ambiguities for detailed review. The sample distribution included 30 cases of underspecification in the SELECT clause, 137 in the FROM clause, and 159 in the WHERE clause. Note that the sum exceeds 200 due to the presence of mixedunderspecification instances, which were counted across the relevant categories. Human annotators reviewed the 200 sampled QA pairs and confirmed that the rewriting process did

Utterance: Which of the top 5 communities by sales volume in Shanghai in July Slot: Intent:

O

O

O

O

O

O

O

O

O

real_estate_project_sales_volume_query

O

B-C

O B-M

2022 have the lowest average price ? B-Y

O

O

O

O

O

O

real_estate_project_average_price_query

Figure 4: Illustration of an utterance with SLU tags. The example features two intents, where ‘B-C’ denotes ‘B-City’ and ‘B-Y’ denotes ‘B-Year’.

not compromise the integrity of the data; specifically, no instances were found where the three types of ambiguities were inadvertently deleted or resolved by the LLM. This robust preservation of ambiguity is attributed to our dual-layered validation strategy. First, our prompt design explicitly incorporates specific “forbidden keywords”—corresponding to the missing information—to constrain the generation process and prevent the model from filling in the gaps. Second, we implemented a rigorous string matching check to verify that these prohibited terms do not appear in the final rewritten queries. This combination of constrained prompting and post-generation verification ensures the accuracy and reliability of the paraphrasing process. A.5

Details of Conversational Clarification Interface

To clarify the mechanism introduced in Section 3.4, we describe the implementation details of our user simulator, which runs in two modes: Fixed and Dynamic. 1. Data Retrieval and Template Construction. When the system correctly detects an underspecification (e.g., a missing city in the scope), the interface looks up the ground-truth value from the dataset’s clarification dictionary (e.g., FROM_clarification). It then constructs a standard response sentence, such as “The correct city is [Beijing].” 2. Dynamic Response Generation (LLM-based Rewriting). In the dynamic scenario, to simulate the diverse and unpredictable nature of real human language, we employ a LLM (Qwen2.5-72B) to rewrite the standard response. We utilize a specialized prompt (see Figure 7) that instructs the LLM to act as a grammar expert, making the sentence more colloquial and using varied sentence structures (e.g., inversions). 3. Reliability Control Mechanism. A critical challenge in automatic generation is ensuring factual consistency. We address this by strict keyword

extraction and validation: • Keyword Extraction: Before generation, the system identifies the critical information slot (e.g., "Beijing") that must be present in the response. • Iterative Validation: The generation process includes a max_retries mechanism (set to 5). After the LLM generates a rewrite, the interface automatically checks if the extracted keyword exists in the new sentence. • Fallback Strategy: If the generated sentence does not contain the keyword after 5 attempts, the system discards the LLM output and defaults to the standard template sentence. This mechanism ensures that the “Dynamic” mode tests the target model’s ability to understand natural language variations without introducing false information that could invalidate the QA evaluation. A.6

Rationale for the Simulated Clarification Interface

While we acknowledge that simulated interactions cannot fully capture the stochastic nature of human behavior, our design choice to utilize a Dynamic Clarification Interface rather than human-in-theloop evaluation is deliberately driven by the specific requirements of constructing a robust benchmark. The rationale behind this decision is threefold: Reproducibility and Standardization for Benchmarking. The primary objective of ODUTQA is to provide a standardized testbed for evaluating SQL generation capabilities under uncertainty. Human-based evaluation, while offering high realism, inherently suffers from high variance, subjectivity, and irreproducibility. A strictly “real” environment would make it mathematically impossible to fairly compare different models or track progress over time, as the “test set” (the variable human responses) would shift with every interaction. Our

simulated approach guarantees that every model is evaluated against a consistent, reliable, and rigorous standard, which is paramount for a scientific benchmark. The Hybrid Design: Controlled Logic with Generative Flexibility. We clarify that our interface is not “rule-based” in the traditional sense of rigid templates. We employ a hybrid architecture to balance logical correctness with linguistic naturalness: • Decision Layer (Deterministic): The decision of what to clarify is governed by logic derived from the dataset’s Gold Labels. This is necessary to ensure the provided information accurately resolves the specific ambiguity in the SQL generation task without introducing hallucinatory noise or irrelevant deviations. • Generation Layer (Probabilistic): The actual dialogue utterances are generated by a state-of-the-art LLM (Qwen2.5-72B) conditioned on the dialogue history. As shown in our manual inspection, this allows for diverse wording, varying sentence structures, and natural phrasing. The model is free to formulate the question as long as it conveys the necessary disambiguating information. This design allows us to “stress test” models with linguistically diverse inputs while maintaining the logical precision required for automated evaluation. Scalability and Cost-Effectiveness. For a benchmark to be practically useful to the research community, it must be scalable. Our automated interface allows for the evaluation of thousands of samples and multiple model iterations at a negligible cost compared to human annotation. This accessibility encourages broader adoption and more frequent testing, which is critical for advancing the field of text-to-SQL. In summary, while we trade off a degree of behavioral realism, we gain the reliability, validity, and operability essential for a scientific benchmark. We believe this is the optimal approach for quantitatively assessing underspecification resolution capabilities. A.7

Dataset Statistics

Table 4 presents the detailed statistics of the ODTQA-FoRe dataset concerning question underspecification, intent type, and table type. The

dataset comprises 5,095 non-underspecified questions (20.29%). It also features questions with underspecifications related to specific SQL clauses: 197 for SELECT (7.85%), 3,274 for FROM (13.04%), and 4,421 for WHERE (17.61%). Notably, the dataset contains 12,118 questions with mixed underspecifications (48.27%), underscoring the complexity of the challenge. Regarding intent, it includes 1,966 single-intent and 23,139 multiintent questions. Based on table sources, there are 3,851 single-table and 21,254 multi-table questions, increasing the reasoning complexity. The dataset features 6 distinct slot types and is built upon 102 Property Information Tables, 4 Real Estate Company Finance Information Tables, and 103 Land Auction Information Tables. To facilitate model development and evaluation, the dataset is partitioned into a training set (14,973), a validation set (5,046), and a test set (5,086). These statistics underscore the comprehensive and representative nature of ODUTQA-MDC, especially in terms of the complexity of underspecification and the diversity of annotation labels.

B

Supplementary experiments

B.1

SLU Task

Table 5 presents the performance comparison of Intent and Slot prediction in queries using BERT and ICL methods. For the BERT model, we fine-tune the “Bert-base-chinese1 ” version on the training set, following the procedure outlined in the main text. The training hyperparameters for BERT are a learning rate of 1 × 10−5 and a batch size of 16. In the ICL scenario, we select a sufficient number of samples from the training set, covering all intent types, to construct the context. These samples included both intent and slot information, enabling LLMs to generate intent and slot labels for new queries in a single pass. When the SLU label format in the LLM output is not standardized, we select the label that most closely matches the output characters. The experimental results indicate that the fine-tuned BERT model achieves better performance in predicting SLU labels compared with ICL methods. However, fine-tuning requires extensive manual annotation, whereas the ICL methods can achieve comparable results with only a few examples. 1

https://huggingface.co/google-bert/bert-base-chinese

Statistics Non-underspecified SELECT underspecification FROM underspecification WHERE underspecification Mixed-underspecification Single intent Multi intents Single Table Multi Tables Slot type Poperty Information Tables Real Estate Enterprise Finance Information Tables Land Auction Information Tables Train Validation Test

Num 5,095 197 3,274 4,421 12,118 1,966 23,139 3,851 21,254 6 102 4 103 14,973 5,046 5,086

Table 4: Dataset Statistics.

B.2

Implementation of baseline

Furthermore, to highlight the challenges our dataset presents to existing methods, we adopt SLUTQA as a baseline approach. SLUTQA follows the design described in its original paper, selecting prompt templates based on the detected user intent and incorporating SLU information into the prompt to guide the LLM in generating more accurate SQL. Notably, SLUTQA does not invoke the clarification interface, as it lacks a built-in mechanism for underspecification detection. B.3

Ablation Study

To evaluate the contribution of each module within the MAIC-TQA framework in handling underspecified queries, we conduct a series of ablation studies on the Qwen3 32B and Qwen3 30B A3B models. These experiments involve removing the clarification mechanisms for intent underspecification (SELECT), scope underspecification (FROM), and condition underspecification (WHERE). The results are presented in Table 6. The results indicate that removing the intent clarification mechanism has the least impact on performance. Specifically, for Qwen3 32B, ECR and EA decrease by 6.13% and 4.45%, respectively. For Qwen3 30B A3B, ECR and EA decrease by 3.69% and 4.81%, respectively. In contrast, removing the scope clarification mechanism most severely affects the ECR metric, leading to a significant drop of 16.92% for Qwen3 32B and 15.31% for Qwen3

30B A3B. Meanwhile, removing the condition clarification mechanism has the most pronounced impact on the EA metric, causing it to fall by 28.59% and 27.29% for the two models. These findings highlight that scope and condition underspecifications are the primary factors limiting performance on this dataset and confirm the effectiveness of our proposed clarification mechanisms in addressing these issues. B.4

Impact of Dynamic Clarification.

As shown in Tables 2, different models exhibit varying performance fluctuations between fixed and dynamic clarification modes. It is important to clarify that this variance is not due to interface design flaws or the provision of incorrect ("bad") clarification information. Instead, our interface employs a strict built-in verification mechanism to ensure reliability: it retrieves canonical fact information from the ground-truth dictionaries only when the system’s detection label is correct. In dynamic mode, while the LLM rewrites this canonical information into conversational paraphrases (e.g., using colloquialisms or inverted structures), the design strictly enforces the inclusion of key entity words. This ensures that the generated content remains semantically fact-accurate. Therefore, the observed performance differences are primarily attributed to the varying robustness of different backbone models against diverse linguistic surface forms, as well as the inherent stochasticity in generation, rather

Model BERT Qwen3 30B Qwen3 32B

Task Intent Slots Intent Slots Intent Slots

P 98.51 99.68 90.57 97.01 88.27 96.07

R 98.61 99.88 91.73 96.79 91.27 97.23

F1 98.56 99.78 91.00 96.90 89.74 96.64

Table 5: Performance of Different Models on SLU Tasks.

Method MAIC-TQA w/o SELECT w/o FROM w/o WHERE

Model Qwen3 32B Qwen3 30B Qwen3 32B Qwen3 30B Qwen3 32B Qwen3 30B Qwen3 32B Qwen3 30B

ECR 97.46 96.32 91.33 92.63 80.54 81.01 90.72 90.34

EA 57.44 54.11 52.99 49.30 35.98 31.84 28.85 26.82

Table 6: Ablation study of the clarification modules in the MAIC-TQA framework.

than factual noise introduced by the clarification interface. Notably, our main conclusions remain stable across both modes, as MAIC-TQA consistently demonstrates significant superiority.

C

Computing Infrastructure Statement

All neural network models are implemented using PyTorch2 v2.3.1. For training the BERT model, we use a single NVIDIA GeForce RTX 4090 GPU. For experiments of LLMs, we perform inference with the SGLang library3 on eight NVIDIA A800SXM4-80GB GPUs. Specifically, we allocate four GPUs to the Qwen3 32B model, four to the Qwen3 30B A3B model. Model responses for Kimi K2 (0711-preview version), GLM 4 plus, and Doubao Seed 1.6 (flash version) are obtained through their respective official APIs 4 5 6 to ensure consistency and reliability of the inference process.

D

Prompts and Functions of Agent

This section summarizes the prompts used for data construction and within the MAIC-TQA frame2

https://pytorch.org/ https://docs.sglang.ai/ 4 Kimi K2: https://api.moonshot.cn/v1 5 GLM 4 plus: https://open.bigmodel.cn/api/paas/ 3

v4 6

Doubao Seed 1.6: https://ark.cn-beijing.volces. com/api/v3

work. The rewriting prompt for data construction is presented in Figure 6. Within the MAIC-TQA framework, the Scope Validator Agent uses the prompt shown in Figure 8 to verify the scope information in user queries, utilizing the Slot Retrieval Tool defined by Algorithm 1. The Table Retrieval Agent then uses the prompt shown in Figure 9 to summarize the target table. Finally, the SQL Generation and Validation Agent utilizes the prompt in Figure 10 to generate and validate SQL queries, and utilizes the tool defined by Algorithm 2 to execute SQL statements.

Algorithm 1 The slotSearchTool used by the SV agent Require: slots: str or List[str]; domain: str Ensure: result: Dict[str, int] Parameter: all_domains: List[str] 1: if domain ∈ / all_domains then 2: Raise error: “Unknown domain" 3: end if 4: if slots is a string then 5: Convert slots to a list with one element 6: end if 7: captions ← all_table_captions[domain] 8: Initialize result ← empty dictionary 9: for each slot in slots do 10: count ← 0 11: for each caption in captions do 12: if slot is a substring of caption then 13: count ← count + 1 14: end if 15: end for 16: result[slot] ← count 17: end for 18: return result

Algorithm 2 The sqlQueryTool used by the SGV agent Require: sql_statement: str; db_name: str Ensure: result: str Parameter: all_db_names: List[str] 1: Define try_execute_on_db(database): 2: Create PostgresQueryExecutor instance with given database 3: Return result of executing sql_statement 4: if db_name ∈ all_db_names then 5: result ← try_execute_on_db(db_name) 6: 7:

return str(result)

8: else if db_name == ‘unknowDomain’ then 9: 10: 11:

for each db_name in all_db_names do result ← try_execute_on_db(db_name) if result is of type list then

12: 13: 14: 15:

return str(result) end if end for

16: 17:

return “Failed to execute SQL on all databases."

18: else 19:

return “Invalid database name: " + db_name 21: end if 20:

Dataset Example Query: 广州市的滨江雅苑的小区环境怎么样? Intent: "未知" Slots: ["B-city", "I-city", "I-city", "O", "B-community", "I-community", "I-community", "I-community", "O", "O", "O", "O", "O", "O", "O", "O", "O"] SELECT-Clarification: {"列名": "绿化率"} FROM-Clarification: {"从化区": "区域"} WHERE-Clarification: {"雅居乐滨江雅苑": "项目 名称"} Intent-Underspecification: "True" Scope-Underspecification: ["从化区", "区域", "Missing"] Condition-Underspecification: ["滨江雅苑", "项目名 称", "不存在"] Table_caption: ["广州市从化区土地成交信息表"] SQL: SELECT "项目名称","绿化率(%)" FROM "广州 市从化区土地成交信息表" WHERE "项目名称" = '雅居乐滨江雅苑'; Answer: 绿化率是25%

Query: How is the environment of Binjiang Garden in Guangzhou City? Intent: "unknown" Slots: ["O", "O", "O", "O", "O", "B-community", "Icommunity", "O", "B-city", "I-city", "O"] SELECT-Clarification: {"Column Name": "Green Coverage Ratio"} FROM-Clarification: {"Conghua District": "District"} WHERE-Clarification: {"Agile Binjiang Garden": "Project Name"} Intent-Underspecification: "True" Scope-Underspecification: ["Conghua District", "District", "Missing"] Condition-Underspecification: ["Binjiang Garden", "Project Name", "not exist"] Table_caption: ["Table of Land Auction Information in Conghua District, Guangzhou"] SQL: SELECT "Project Name","Green Coverage Ratio" FROM "Table of Land Auction Information in Conghua District, Guangzhou" WHERE "Project Name" = 'Agile Binjiang Garden'; Answer: The Green Coverage Ratio is 25%.

Figure 5: QA example.

Rewriting Prompt Your input is a query obtained by filling in city and district names based on a template. Please process your input <Query> as follows; do not answer the question directly. The main goal is to rewrite the <Query> while ensuring the meaning remains unchanged and the <Keywords> are preserved: 1. <Keywords> listed must not be altered and must appear in the <Rewritten_query>. <Keywords> are the city name, district name, year, month, or time range. 2. <Forbidden_keywords> listed must not appear in the rewritten query. You can only use approximate phrasing. The intent of the <Rewritten_query> is to phrase a vague question regarding the <Forbidden_keywords>. 3. You only need to rewrite the question, not answer it. Rewriting methods include, but are not limited to, inversion and synonym replacement. 4. "<Forbidden_keywords>: 'None'" indicates there are no forbidden words. 5. You can be creative and increase sentence diversity while ensuring the meaning remains unchanged, <Keywords> are preserved, and <Forbidden_keywords> do not appear. ############Example 1############## <Query>:Which environment is better when comparing Yuyue Guangnian and Nanan Chaoming in Yuhuatai District, Nanjing City? <Keywords>:['Yuyue Guangnian', 'Nanan Chaoming', 'Yuhuatai District', 'Nanjing', ] <Forbidden_keywords>:Greening Rate (%) <Rewritten Query>:When analyzing from the perspective of neighborhood environment, which is better between Yuyue Guangnian and Nanan Chaoming in Nanjing's Yuhuatai District? ############Example 2############## ...... #########Complete the following######### <Query>:{query} <Keywords>:{keywords} <Forbidden_keywords>:{forbidden_keywords} <Rewritten Query>:

Figure 6: Query rewriting prompts for dataset construction.

Rewriting Prompt for Dynamic Clarification Interface You are a grammar rewriting expert. Please rewrite the input sentence to make it sound more natural and human-like. Do not change the original meaning of the sentence, and do not output any explanations or notes. You may use various grammatical structures like inversion, add modal particles, and make it as colloquial as possible. Note: The keyword '{keyword}' must be included. Now, please rewrite the following sentence: {sentence}

Figure 7: Prompt for sentence rewriting used in the dynamic clarification interface.

Prompt for Scope Validator Agent You are a slot classification agent. Based on the provided input, you are required to use a tool to perform slot verification and classify the slots accordingly. Note: In the final output, only the classification results should be included. Do not include any thought processes or other additional content. ### Input Description ###: <Query>: A string representing the original sentence from which the slots are extracted. <Domain>: A string indicating the question domain; one of 'realEstateSalesField', 'landInformationField', or 'enterpriseFinanceField'. <Slots>: A list in the format "type:slot", representing the extracted slots and their corresponding types from the <Query>. <Target Slot Types>: A list of slot types that are required to appear in the current question. ### Tool Description ###: You must use a retrieval tool named "slotSearchTool", which is designed to verify whether a slot or a combination of slots exists within table headers under the specified <Domain>. "slotSearchTool" Input: 'slots': A 'str' or 'List[str]' representing the slot(s) or slot combination(s) to be searched. 'domain': A 'str' representing the question domain. Return: A Dict[str, int], where each key is a slot string and the value indicates the number of tables found (0 means not found, 1 means found in 1 table, n means found in n tables). ### Processing Procedure ###: ========================Step 1: Slot Verification ======================== 1. Extract Target Slots: Filter all slots in <Slots> that match the <Target Slot Types>. 2. Invoke Tool for Verification: - Single-slot Verification: Search each target slot individually and record the results. - Combined-slot Verification: Combine target slots (e.g., city + district) according to their order of appearance in <Query>, then perform combined verification. ============Step 2: Slot Classification (Apply rules in priority order) ============= 1. 'Missing': - If a target slot type does not appear at all in <Slots>, classify it as ['', slot_type, 'Missing']. 2. 'Unmatch' (Combination Mismatch): - All individual slot checks return values > 0 (i.e., all exist individually); - But the combination slot query returns 0; - Then both slots in the combination are classified as [slot, slot_type, 'Unmatch']. - Important: Once classified as 'Unmatch', these slots cannot be reclassified as 'Error' or 'Correct'. 3. 'Error' (Retrieval Failed): - If a slot is present in '<Slots>' but its single-slot verification result is 0, classify it as [slot, slot_type, 'Error']. 4. 'Correct' (Fully Matched): - All target slot types are present; - All individual slot queries return values > 0; - Combined slot query also returns > 0; - Then each involved slot is classified as [slot, slot_type, 'Correct']. ############ [Example] ########## <Query>: "Please provide the building density of Dongping Town in Shanghai and Yuntai Yuanzhu in Jianye District, Nanjing." <Domain>: 'realEstateSalesField' <Slots>: ['city:Shanghai', 'community:Dongping Town', 'city:Nanjing', 'district:Jianye District', 'community:Yuntai Yuanzhu'] <Target Slot Types>: ['city', 'district'] → Input to "slotSearchTool": (['Shanghai', 'Nanjing', 'Jianye District', 'Jianye District, Nanjing'], 'realEstateSalesField') → Return: {'Shanghai': 18, 'Nanjing': 11, 'Jianye District': 0, 'Jianye District, Nanjing': 0} → Classification Result: [['Shanghai', 'city', 'Correct'], ['', 'district', 'Missing'], ['Nanjing', 'city', 'Correct'], ['Jianye District', 'district', 'Error']]

Figure 8: Prompt for slots classification.

Summary Prompt for Table Retrieval Agent You are an information extraction assistant. Based on the <Dialog> conversation below, extract the table names relevant to the user's query. ### Task Instructions 1. In the <Dialog>, "system" represents the system's follow-up questions based on the user's original input, and "user" represents the user's supplementary information in response to errors or omissions; 2. The user’s original query may contain mistakes — you should make judgments based on the user’s supplemental input; 3. The <Summary> should be a list consisting of a geographic region + table name, such as "Table of Property Transaction Prices in Haidian District, Beijing"; ############ Example 1 ############## <Dialog>: User: Could you tell me how many property units were sold in November 2020 in Park No.1 in Daxing District, Beijing, and Jing'an No.1 in Shanghai? System: Your input lacks a region name. Please provide the correct region. User: The correct region should be Jing'an District. <Summary>: ["Table of Property Transaction Prices in Jing'an District, Shanghai", "Table of Property Transaction Prices in Daxing District, Beijing"] ############ Example 2 ############## <Dialog>: User: Please check the average transaction prices in June 2020 for Jinyue Mansion in Miyun District, Beijing and Hyde Apartment in Yuhang District, Hangzhou. <Summary>: ["Table of Property Transaction Prices in Miyun District, Beijing", "Table of Property Transaction Prices in Yuhang District, Hangzhou"] ······ ########## Complete the following# ######### <Dialog>: {query} <Summary>: Figure 9: Prompt for table caption summarization.

Prompt for SQL Generation and Validation Agent You are an assistant for SQL generation and validation. ### Input Components <Dialog>: A conversation containing system follow-up prompts and user-provided corrections. - system: Follow-up questions posed by the system after detecting errors in the user’s original query. - user: Corrected information provided by the user in response to the system's prompt. <Domain>: The domain of the query, which also serves as an input to the `sqlQueryTool`. <SLOTS>: Key database information extracted from the user’s original question. <Table_Captions>: Predicted table titles relevant to the database. ### Task Workflow ============================= Step 1: SQL Generation ============================= 1. Analyze the content of the <Dialog> to identify the user's query intent. 2. Important: Always prioritize the corrected information provided by the user over the erroneous information in the original query. 3. Generate an SQL query using the provided <SLOTS> and <Table_Captions>. 4. Strictly follow the format shown in the examples below. ############ Example 1 ############## <Dialog>: User: What is the operating profit of Lishui Economic Development Group? System: Your input is missing the year. Please provide a year between 2019 and 2022. User: I'm interested in the year 2021. <Domain>: enterpriseFinanceField <SLOTS>: {'Lishui Economic Development Group': 'Enterprise Name'} <Table_Captions>: National Enterprise Finance Table 2021 <SQL>: SELECT "Enterprise Name", "Operating Profit" FROM "National Enterprise Finance Table 2021" WHERE "Enterprise Name" = 'Nanjing Lishui Economic and Technological Development Group Co., Ltd.'; ############ Example 2 ############## <Dialog>: User: What were the profits of Tahoe Group Co., Ltd. and Sunshine New Industry Real Estate Co., Ltd. in 2019? <Domain>: enterpriseFinanceField <SLOTS>: {'2019': 'Year', 'Tahoe Group Co., Ltd.': 'Enterprise Name', 'Sunshine New Industry Real Estate Co., Ltd.': 'Enterprise Name'} <Table_Captions>: National Enterprise Finance Table 2019 <SQL>: SELECT "Enterprise Name", "Operating Profit" FROM "National Enterprise Finance Table 2019" WHERE "Enterprise Name" IN ('Tahoe Group Co., Ltd.', 'Sunshine New Industry Real Estate Co., Ltd.'); ······ =========================== Step 2: SQL Validation and Execution ====================== Use the "sqlQueryTool" (input: SQL query and domain) to validate the generated SQL. Note: You are allowed to call the tool only once for validation. "sqlQueryTool" input: - sql_statement: str, the SQL query to execute - domain: str, the domain of the query Returns: - The result of the SQL execution ================================ Step 3: Final Output ============================= After executing the SQL using the tool, construct the final output in the following dictionary format: ```json { "sql": "<The actual SQL statement executed, ending with a semicolon — do not omit it>", "result": "<The result of the SQL execution, or the error message if execution failed>", "note": [] or [['slot content', 'slot type', 'not exist'] , ...] }```

Figure 10: Prompt for SQL generation and condition underspecification detection.

Related documents

Record · ID 120628 · SHA-256 5dbefc2ae4ac6cf6
Conceptio Open Knowledge Archive — every document is proof-bundled with source, license, and retrieval metadata.