NL2SQL

NL2SQL (Natural Language to SQL) is an AI-driven process: It uses Large Language Models (LLMs) to translate plain English questions directly into executable SQL queries, democratizing database access.

NL2SQL systems leverage advanced Natural Language Processing (NLP) and LLMs to bridge the gap between human language and structured data. The core mechanism involves schema linking (mapping words like 'employee' to the correct database table/column) and query synthesis, generating a syntactically correct SQL statement. For example, a user input like 'List all customers from California with orders above $1000 last month' instantly generates a complex `SELECT` query. This capability bypasses the need for deep SQL expertise, empowering non-technical users (analysts, executives) to retrieve critical business insights faster, accelerating data-driven decision-making across the enterprise.

https://aws.amazon.com/blogs/ai/enterprise-grade-natural-language-to-sql-generation-using-llms-balancing-accuracy-latency-and-scale/