mlsanityData to 14 Oct 2026

Beyond Text-to-SQL for IoT Defense: A Comprehensive Framework for Querying and Classifying IoT Threats

arXiv 2406.17574 ↗First posted 25 Jun 2024cs.CLcited by 1

Not on the map. Why?

Abstract (arXiv)

Recognizing the promise of natural language interfaces to databases, prior studies have emphasized the development of text-to-SQL systems. While substantial progress has been made in this field, existing research has concentrated on generating SQL statements from text queries. The broader challenge, however, lies in inferring new information about the returned data. Our research makes two major contributions to address this gap. First, we introduce a novel Internet-of-Things (IoT) text-to-SQL dataset comprising 10,985 text-SQL pairs and 239,398 rows of network traffic activity. The dataset contains additional query types limited in prior text-to-SQL datasets, notably temporal-related queries. Our dataset is sourced from a smart building's IoT ecosystem exploring sensor read and network traffic data. Second, our dataset allows two-stage processing, where the returned data (network traffic) from a generated SQL can be categorized as malicious or not. Our results show that joint training to query and infer information about the data can improve overall text-to-SQL performance, nearly matching substantially larger models. We also show that current large language models (e.g., GPT3.5) struggle to infer new information about returned data, thus our dataset provides a novel test bed for integrating complex domain-specific reasoning into LLMs.

Key facts. Cited by 1 paper in the map (data through 14 Oct 2026). Builds on 29 of its 49 references that are in the map. First posted on arXiv 25 Jun 2024.

Builds on

29 of 49 references.

References · 29

  1. 2014Adam: A Method for Stochastic Optimizationcited by 37,240
  2. 2021Evaluating Large Language Models Trained on Codecited by 8,320
  3. 2019BART: Denoising Sequence-to-Sequence Pre-training for Natural Language Generation, Translation, and Comprehensioncited by 5,893
  4. 2022Scaling Instruction-Finetuned Language Modelscited by 3,024
  5. 2018Spider: A Large-Scale Human-Labeled Dataset for Complex and Cross-Domain Semantic Parsing and Text-to-SQL Taskcited by 1,139
  6. 2017Seq2SQL: Generating Structured Queries from Natural Language using Reinforcement Learningcited by 687
  7. 2023DIN-SQL: Decomposed In-Context Learning of Text-to-SQL with Self-Correctioncited by 477
  8. 2019RAT-SQL: Relation-Aware Schema Encoding and Linking for Text-to-SQL Parserscited by 424
  9. 2021PICARD: Parsing Incrementally for Constrained Auto-Regressive Decoding from Language Modelscited by 411
  10. 2023Text-to-SQL Empowered by Large Language Models: A Benchmark Evaluationcited by 385
  11. 2022UnifiedSKG: Unifying and Multi-Tasking Structured Knowledge Grounding with Text-to-Text Language Modelscited by 231
  12. 2019CoSQL: A Conversational Text-to-SQL Challenge Towards Cross-Domain Natural Language Interfaces to Databasescited by 185
17 more
  1. 2023C3: Zero-shot Text-to-SQL with ChatGPTcited by 164
  2. 2017SQLNet: Generating Structured Queries From Natural Language Without Reinforcement Learningcited by 135
  3. 2021TABBIE: Pretrained Representations of Tabular Datacited by 111
  4. 2017Learning a Neural Semantic Parser from User Feedbackcited by 99
  5. 2018TypeSQL: Knowledge-based Type-Aware Neural Text-to-SQL Generationcited by 81
  6. 2019Text-to-SQL Generation for Question Answering on Electronic Medical Recordscited by 77
  7. 2019Representing Schema Structure with Graph Neural Networks for Text-to-SQL Parsingcited by 74
  8. 2018Robust Text-to-SQL Generation with Execution-Guided Decodingcited by 52
  9. 2021TabularNet: A Neural Network Architecture for Understanding Semantic Structures of Tabular Datacited by 36
  10. 2022Proton: Probing Schema Linking Information from Pre-trained Language Models for Text-to-SQL Parsingcited by 30
  11. 2020RPT: Relational Pre-trained Transformer Is Almost All You Need towards Democratizing Data Preparationcited by 27
  12. 2021Retrieving Complex Tables with Multi-Granular Graph Representation Learningcited by 24
  13. 2022Measuring and Improving Compositional Generalization in Text-to-SQL via Component Alignmentcited by 16
  14. 2021Exploring Decomposition for Table-based Fact Verificationcited by 11
  15. 2022Table Retrieval May Not Necessitate Table-specific Model Designcited by 11
  16. 2023Towards Understanding the Generalization of Medical Text-to-SQL Models and Datasetscited by 9
  17. 2018Peek-a-Boo: I see your smart home activities, even encrypted!cited by 8

Built on by

Cited by year (2026 to 14 Oct)

Citing papers per year: 2026: 1.

1 paper.

  1. 2026From Interpretability to Control: Insights from Six Years of the TrustNLP Workshopcited by 0

Similar, not cited

Close in wording, no citation either way

  1. 2025ChatIoT: Large Language Model-based Security Assistant for Internet of Things with Retrieval-Augmented Generation
  2. 2024Unraveling Attacks in Machine Learning-based IoT Ecosystems: A Survey and the Open Libraries Behind Them
  3. 2022On the Security Vulnerabilities of Text-to-SQL Models
  4. 2025What's on My Network? Using Large Language Models to Identify Real-World IoT Devices at Scale
  5. 2024Cyber Knowledge Completion Using Large Language Models
  6. 2025Large Language Models in the IoT Ecosystem -- A Survey on Security Challenges and Applications
  7. 2025Large Language Model-driven Security Assistant for Internet of Things via Chain-of-Thought
  8. 2026Rethinking On-Device LLM Reasoning: Why Analogical Mapping Outperforms Abstract Thinking for IoT DDoS Detection ↗