Text-to-SQL | BestHub

DataFunSummit

Jan 24, 2025 · Artificial Intelligence

Exploring LLM‑Based Generative Business Intelligence (GenBI): Architecture, Implementation, and Lessons Learned

With the rise of LLM‑based generative AI, this article examines the emerging GenBI (Generative Business Intelligence) paradigm, detailing why self‑serving analytics are needed, the progress of Text‑to‑SQL, an LLM‑driven agent architecture, practical AWS Bedrock implementation, technical choices, lessons learned, and future outlook.

AWS BedrockAgentic AIGenerative AI

0 likes · 18 min read

Exploring LLM‑Based Generative Business Intelligence (GenBI): Architecture, Implementation, and Lessons Learned

Data Thinking Notes

Jan 7, 2025 · Databases

Unlocking LLM-Powered Text-to-SQL: From Basics to Cutting-Edge Techniques

This article provides a comprehensive overview of LLM-based Text-to-SQL technology, covering its background, evolution, challenges, various LLM-driven methods, benchmark datasets, evaluation metrics, and future research directions to guide researchers and practitioners in advancing natural language interfaces for databases.

DatabaseLLMNatural Language Processing

0 likes · 18 min read

Unlocking LLM-Powered Text-to-SQL: From Basics to Cutting-Edge Techniques

DaTaobao Tech

Mar 29, 2024 · Artificial Intelligence

Text-to-SQL with Large Language Models: DIN-SQL Approach

The DIN‑SQL approach enhances Text‑to‑SQL performance by using large language models in a decomposed in‑context learning framework with schema linking, query classification, SQL generation, and self‑correction modules, achieving state‑of‑the‑art 85.3% execution accuracy on the Spider benchmark by breaking complex queries into manageable sub‑tasks.

AI researchDatabase QueryingNLP

0 likes · 34 min read

Text-to-SQL with Large Language Models: DIN-SQL Approach

JD Retail Technology

Oct 26, 2023 · Artificial Intelligence

Leveraging Large Language Models for Text-to-SQL: Prompt Design and End-to-End Pipeline

This article explains how large language models can be used to convert natural language queries into SQL statements, describes two main approaches—direct generation and fine‑tuned open‑source models—details prompt engineering techniques, and outlines an end‑to‑end pipeline that executes the generated SQL and summarizes results.

ChatGLMLLMPrompt Engineering

0 likes · 7 min read

Leveraging Large Language Models for Text-to-SQL: Prompt Design and End-to-End Pipeline

DataFunTalk

May 12, 2020 · Artificial Intelligence

Semantic Parsing for Text-to-SQL: Datasets, Models, Evaluation, and Applications

This article reviews the Text-to-SQL semantic parsing task, covering its motivation, dataset landscape, major model architectures such as pointer networks, sequence‑to‑set, and grammar‑based approaches, evaluation metrics, the newly built DuSQL dataset and DuParser system, real‑world deployments, and remaining research challenges.

AIDatabaseNatural Language Processing

0 likes · 20 min read

Semantic Parsing for Text-to-SQL: Datasets, Models, Evaluation, and Applications