Tagged articles
SQL Generation
44 articles · Page 1 of 1
This article details a production-grade SQL generation engine using a semantic layer, NL2DSL via RAG, and deterministic DSL2SQL translation, achieving 85-90% accuracy through ambiguity detection, validation, permission injection, and feedback loops.
DSL2SQLData EngineeringLLM
0 likes · 15 min read

This article presents a comprehensive engineering framework for production Text-to-SQL systems, covering schema contracts, prompt engineering, retrieval with permission-aware evidence closure, multi-layer SQL validation, execution isolation, and evaluation methodologies centered on business correctness and security boundaries.
LLM ApplicationsSQL GenerationSchema Management
0 likes · 43 min read

Enterprise Data Agents face a fundamental shift from merely generating syntactically correct SQL to reliably interpreting business semantics, prompting a new architecture that inserts a semantic layer and a deterministic compiler to produce verifiable, governance‑ready queries.
Business CompilerData AgentNL2SQL
0 likes · 21 min read


ITPUBJul 31, 2026 · Databases
The article explains that AI will not replace data warehouses but will transform them by introducing automated modeling, AI‑generated SQL, intelligent resource scheduling, and natural‑language query interfaces, enabling business users to interact with data directly and turning warehouses into self‑optimizing, intelligent decision engines.
AIAutomated ModelingNatural Language Query
0 likes · 8 min read

SQL Chat, an open‑source AI‑driven database client with 5.8K stars, lets you converse in natural language to generate and run SQL across MySQL, PostgreSQL, MSSQL, TiDB Cloud and OceanBase, while keeping data local and offering Docker self‑hosting, but it still cannot replace full‑featured tools for complex tasks.
AI SQL clientDatabase explorationDocker
0 likes · 10 min read

The article introduces the Exercises‑Dataset, a 1,324‑exercise structured collection with multilingual descriptions and GIFs, and walks through its setup.html tool that auto‑generates SQL, provides API client code in seven languages, and creates LLM prompts, while noting media licensing considerations.
API clientGitHub TrendingSQL Generation
0 likes · 5 min read

This article walks through using DataWorks Data Agent to automate end‑to‑end data‑warehouse development—from preparing source tables and a structured requirement document, uploading it, crafting task commands, selecting execution modes and models, to the agent generating SQL, building workflows, publishing them, and producing a final report—all without writing SQL manually.
AI automationData AgentDataWorks
0 likes · 16 min read

The article details how Alibaba’s production‑grade Verify‑Data Agent Skill replaces manual, multi‑SQL data validation with a single natural‑language command, automating table discovery, SQL generation, execution, and review‑level reporting, achieving up to 30‑minute turnaround, comprehensive coverage, and robust risk controls for big‑data pipelines.
Agent AutomationSQL Generationbig data
0 likes · 28 min read

The article outlines how large language models can automate repetitive data‑warehouse tasks—from natural‑language SQL generation and standardized modeling to automated code review, metadata management, multimodal data handling, and self‑service analytics—presenting a three‑phase implementation roadmap for measurable efficiency gains.
AIChatBIDataOps
0 likes · 9 min read

This tutorial shows how to replace manual MySQL query writing with Spring AI by extracting the database schema into Markdown, prompting a large language model to produce precise SQL, and wiring the result through Spring Boot services, a controller, and execution logic.
AIBackendDashScope
0 likes · 11 min read

As AI agents begin generating hundreds of lines of code and rapidly iterating database changes, traditional DBA manual review becomes obsolete; NineData’s AI‑native cloud‑native platform leverages intelligent SQL generation, automated review, and ChatDBA to boost development efficiency tenfold, cut repetitive work by 90%, and deliver high‑availability, secure, multi‑cloud data management at enterprise scale.
AI databasesDevOpsSQL Generation
0 likes · 15 min read

This article walks through building an enterprise‑grade Text2SQL system using Qwen3.5‑Plus, covering model selection, schema injection, system architecture, code integration, security checks, accuracy engineering, common pitfalls, and future outlook for data democratization.
SQL GenerationSchema Injectionenterprise AI
0 likes · 20 min read

The article explains why directly letting large language models generate SQL leads to poor accuracy, and presents a production‑grade engine that combines a semantic knowledge layer, RAG‑enhanced NL‑to‑DSL conversion, and a deterministic DSL‑to‑SQL translator to achieve 85‑90% correctness in real‑world deployments.
DSL2SQLNL2DSLRAG
0 likes · 13 min read

This article explores how artificial intelligence enhances data warehouses by automating model design, generating SQL from natural language, optimizing resource scheduling, and enabling business users to converse directly with data, while also reviewing leading tools and future cloud‑native trends.
AIAutomated ModelingNatural Language Query
0 likes · 7 min read

This article explains how Retrieval‑Augmented Generation (RAG) combines vector databases with large language models to let non‑technical users ask natural‑language questions and receive precise SQL statements, detailing the workflow, architecture, chunking methods, performance gains, and remaining challenges.
LLMRAGSQL Generation
0 likes · 17 min read

This article explores integrating DeepSeek AI into VS Code and IntelliJ IDEA to automate coding tasks like SQL generation, test creation, and refactoring, detailing setup methods, practical examples, team adoption strategies, and future AI pair-programming trends.
AI-assisted programmingDeepSeekIntelliJ IDEA
0 likes · 9 min read

This article explores how large language models break the natural‑language‑to‑SQL barrier, outlines the challenges of NLP‑driven data retrieval, compares Text2SQL and Text2DSL approaches, and proposes a unified data service and metric platform to power enterprise‑grade ChatBI solutions.
AIChatBIData Engineering
0 likes · 22 min read

This article explores the emerging field of prompt engineering, detailing its fundamentals, advanced strategies such as chain‑of‑thought, ReAct, and structured frameworks, and demonstrates practical applications in AI agents for data retrieval, SQL generation, and market insight, offering actionable guidance for developers and business users alike.
AI agentsData RetrievalRAG
0 likes · 42 min read

The article demonstrates building an enterprise HR management system on the Chengwu low-code platform, using Deepseek to generate SQL for employee, attendance, and salary tables; AMIS to create frontend pages for employee and attendance management; and LogicFlow to automate leave approval workflows, showcasing a complete low-code development approach.
AMisDeepSeekHRMS
0 likes · 12 min read

This article demonstrates how to build a property management system using the Chengwu low-code platform combined with DeepSeek AI for automatic SQL generation, covering owner management, fee collection, repair workflows, and deployment with role-based permissions.
ChengwuDeepSeekSQL Generation
0 likes · 10 min read

This article shows how to rapidly build a configurable cadre management system using AI-generated SQL schemas and the Chengwu low-code platform, covering eight database tables, auto-generated UI pages, and drag-and-drop workflow configuration for approval processes, reducing development time from months to days.
AI-assisted developmentChengwu low-codeDatabase Design
0 likes · 12 min read

This article explains how constrained decoding, built on context‑free grammars, Jinja templates, and the XGrammar engine, can enforce strict SQL syntax and custom business rules during LLM generation, enabling reliable, production‑grade NL‑to‑SQL services.
CFGJinjaLLM
0 likes · 37 min read

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.
Data SynthesisNL2SQLSQL Generation
0 likes · 2 min read

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


Qborfy AIMar 28, 2025 · Artificial Intelligence
This article walks readers through the fundamentals of prompt engineering—covering role, context, instruction, examples, and output formatting—then demonstrates a step‑by‑step construction of a sophisticated SQL‑generation prompt, complete with concrete code snippets, best‑practice tips, and reference resources.
AI Prompt DesignPractical ExamplesSQL Generation
0 likes · 21 min read

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

This guide introduces the open‑source DrawDB tool, walks through Docker‑based installation, demonstrates designing tables and relationships using a mall e‑commerce permission module example, and covers SQL import/export, theme switching, and template customization, helping developers efficiently create database schemas.
Database DesignDockerDrawDB
0 likes · 6 min read

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.
AIMetaSQLNL2SQL
0 likes · 17 min read

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, 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.
AIFault DiagnosisRAG
0 likes · 10 min read

Baidu’s DATAPILOT platform combines natural‑language interaction with GPU‑accelerated Spark‑RAPIDS to turn complex, multi‑table SQL queries into seconds‑fast results, boosting ad‑revenue analysis efficiency by up to five‑fold while reducing infrastructure costs.
Apache SparkBaiduGPU acceleration
0 likes · 10 min read

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 enterpriseSQL Generationknowledge graph
0 likes · 17 min read


StarRocksMay 14, 2024 · Artificial Intelligence
Tencent Games tackled the low accuracy of AI‑generated SQL in production by combining large language models with a StarRocks lake‑warehouse, introducing a semantic layer, async materialized views, and an agent‑based multi‑intelligence framework, ultimately raising one‑shot SQL correctness to 89% and cutting delivery time from 2 hours to 0.33 hours.
AIData EngineeringLLM
0 likes · 13 min read


StarRocksApr 25, 2024 · Artificial Intelligence
The April 16 online meetup by Tencent Game Data and StarRocks explored AI‑generated SQL, tackled NL2SQL challenges, showcased a demo that lifted one‑shot accuracy to 89%, and introduced StarRocks AutoMV technology that automates materialized‑view recommendation and merging to accelerate data‑warehouse queries.
AIAutoMVMaterialized View
0 likes · 9 min read

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.
ChatGLMLLMSQL Generation
0 likes · 7 min read


ITPUBJun 5, 2023 · Databases
This article explores why ChatGPT has become a breakthrough AI technology, reviews past AI‑database integrations, and envisions multiple future use cases—including natural‑language SQL generation, performance tuning, schema and architecture design, data analysis, and governance—showing how developers, DBAs, and analysts might benefit.
AIChatGPTSQL Generation
0 likes · 9 min read

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.
DashboardFrontend DevelopmentMetadata Computation
0 likes · 17 min read

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.
SQL Generationbig datadata exploration
0 likes · 13 min read

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.
Fluent-MyBatisMyBatisMyBatis Plus
0 likes · 8 min read

This article explains the design, features, and technical implementation of Youzan’s BI platform, covering its target users, visualization workflow, supported chart types, filtering, permissions, drill‑down, calculated fields, SQL generation logic, and future development directions.
AnalyticsBISQL Generation
0 likes · 20 min read


ITPUBSep 14, 2020 · Big Data
This article explains how the ADC (Alibaba DChain Data Converger) project automatically creates large real‑time tables by letting users configure metrics on the front‑end, then generating and publishing SQL through a pipeline that leverages design patterns, priority queues, and tree‑based data structures for efficient cross‑database processing.
FlinkSQL Generationdata pipeline
0 likes · 15 min read

This article explains how the Alibaba DChain Data Converger (ADC) automatically creates wide‑table SQL for real‑time cross‑database analytics by using a pipeline architecture, priority‑queue‑driven task scheduling, and specific design patterns to handle metadata, joins, and resource management.
SQL Generationbig datapriority queue
0 likes · 13 min read

Meituan‑Dianping’s Dashiang Cube is a multi‑source BI reporting platform that unifies MySQL, Kylin, Elasticsearch and plain‑text data via a common SQL layer, generates dialect‑specific queries, performs custom back‑tracking inner and left outer joins across heterogeneous sources, supports scripted metric calculations, permission controls, and a reusable UI component library for self‑service reporting.
BIJavaJoin Algorithms
0 likes · 14 min read


ITPUBSep 14, 2017 · Artificial Intelligence
Salesforce’s recent research introduces Seq2SQL, a reinforcement‑learning‑driven sequence‑to‑sequence model that translates natural‑language questions into SQL queries, eliminating the need to learn SQL, and includes the large WikiSQL dataset built from crowdsourced NL‑SQL pairs for training and evaluation.
AISQL GenerationSeq2SQL
0 likes · 6 min read
