SQL generation | BestHub

DataFunSummit

Jun 6, 2025 · Artificial Intelligence

Automating High‑Quality NL2SQL Data Synthesis with Intermediate Representations

This work tackles the difficulty of incorporating extensive domain knowledge into in‑domain NL2SQL tasks by proposing an intermediate‑representation‑based data synthesis method that decouples knowledge compliance from SQL generation, enabling automated creation of high‑quality training data with 60× human efficiency and over 97% accuracy.

NL2SQLSQL generationdata synthesis

0 likes · 2 min read

Automating High‑Quality NL2SQL Data Synthesis with Intermediate Representations

Youzan Coder

Jun 6, 2025 · Artificial Intelligence

How AI Agents Turn Manual Data Retrieval into Fully Automated Insights

This article examines the challenges of manual data extraction in data‑driven enterprises, explains why large language models alone fall short, and details how the Cursor‑Agent framework automates end‑to‑end querying, knowledge‑base integration, and result validation to become a self‑sufficient "data master" for both technical and non‑technical users.

AI AgentCursor-AgentData Automation

0 likes · 26 min read

How AI Agents Turn Manual Data Retrieval into Fully Automated Insights

Spring Full-Stack Practical Cases

Mar 17, 2025 · Backend Development

Generate SQL with Spring AI: LLM‑Powered Queries in Spring Boot 3

This article demonstrates how to use Spring AI with a large language model to automatically generate and execute SELECT SQL statements in a Spring Boot 3 application, covering dependency setup, configuration files, prompt templates, controller implementation, and testing with example scripts.

JavaLLMSQL generation

0 likes · 9 min read

Generate SQL with Spring AI: LLM‑Powered Queries in Spring Boot 3

DataFunSummit

Feb 3, 2025 · Databases

NL2SQL from a Database Perspective: Overview, History, and Laboratory Projects (GAR, MetaSQL, PURPLE)

This article presents a comprehensive overview of NL2SQL, covering its definition, motivations, application scenarios, key technical components, evaluation metrics, historical development stages, and detailed descriptions of three laboratory projects—GAR, MetaSQL, and PURPLE—along with future research directions and a Q&A session.

AIDatabaseMetaSQL

0 likes · 17 min read

NL2SQL from a Database Perspective: Overview, History, and Laboratory Projects (GAR, MetaSQL, PURPLE)

Aikesheng Open Source Community

Nov 11, 2024 · Databases

ChatDBA: An AI‑Powered Intelligent Assistant for Database Fault Diagnosis and Management

ChatDBA is an AI‑driven conversational system developed by Shanghai Aikesheng that assists DBAs with fault diagnosis, knowledge learning, SQL generation and optimization by leveraging large language models, RAG architecture, and advanced retrieval and document‑processing techniques.

ChatDBADatabase AIFault Diagnosis

0 likes · 10 min read

ChatDBA: An AI‑Powered Intelligent Assistant for Database Fault Diagnosis and Management

DataFunSummit

Nov 8, 2024 · Artificial Intelligence

ChatDBA: An AI‑Powered Database Fault Diagnosis Assistant Using Retrieval‑Augmented Generation

ChatDBA, developed by Shanghai Aikesheng, is an AI-driven database operation assistant that leverages large language models and Retrieval‑Augmented Generation to provide fault diagnosis, knowledge learning, SQL generation and optimization, addressing challenges such as vague outputs, complex troubleshooting logic, and memory management through a structured architecture and multi‑modal retrieval strategies.

AIDatabaseFault Diagnosis

0 likes · 10 min read

ChatDBA: An AI‑Powered Database Fault Diagnosis Assistant Using Retrieval‑Augmented Generation

DataFunTalk

Oct 4, 2024 · Artificial Intelligence

Building a Commercial Intelligence Assistant with Baidu's Wenxin Large Model: Methods, Optimizations, and Future Outlook

This article shares the exploration and practice of using Baidu's Wenxin large model to build a commercial intelligence assistant, highlighting its impact on business revenue and user experience, code generation, knowledge graph integration, database query optimization, and visual analytics for enhanced data analysis.

AI for enterpriseBusiness IntelligencePrompt Engineering

0 likes · 17 min read

Building a Commercial Intelligence Assistant with Baidu's Wenxin Large Model: Methods, Optimizations, and Future Outlook

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

Shopee Tech Team

Aug 25, 2022 · Frontend Development

Datav: Building an Efficient Data Visualization Platform for Dashboard Development

Datav, Shopee’s internal low‑code data‑visualization platform, automates dashboard creation by providing a DSL‑driven designer, reusable chart components, and auto‑generated SQL, cutting project cycles from roughly 40 to 20 days and front‑end effort from ten to three person‑days while streamlining data‑source integration and permission management.

DashboardData VisualizationFrontend Development

0 likes · 17 min read

Datav: Building an Efficient Data Visualization Platform for Dashboard Development

ByteDance Data Platform

Jul 18, 2022 · Big Data

Unlocking Real‑Time Data Quality: ByteDance’s Dynamic Exploration Solution

This article explains how ByteDance’s dynamic data exploration tool improves data quality assurance by replacing time‑consuming SQL validation with real‑time, sample‑based profiling, detailing its problem background, core features, technical architecture, front‑end rendering techniques, operation‑stack management, and future enhancements.

Big DataSQL generationdata exploration

0 likes · 13 min read

Unlocking Real‑Time Data Quality: ByteDance’s Dynamic Exploration Solution

Top Architect

Oct 10, 2021 · Backend Development

Using Fluent MyBatis for Complex Queries and Comparing It with MyBatis and MyBatis‑Plus

This article demonstrates how to use Fluent MyBatis to build complex SQL queries for a student_score table, compares the implementation with native MyBatis XML and MyBatis‑Plus, and discusses code generation settings and practical trade‑offs, providing full code examples and performance insights.

Backend DevelopmentFluent MyBatisMyBatis

0 likes · 8 min read

Using Fluent MyBatis for Complex Queries and Comparing It with MyBatis and MyBatis‑Plus