Dino Esposito explains JSON-to-rowset native support in SQL Server 2016 and provides a realistic perspective of data query when you have JSON data stored in the database.

Currently, when a user asks natural language questions over custom data sources, two main approaches come into play: text-to-SQL or retrieval-augmented generation (RAG).

Text-to-SQL is one of the most useful and direct LLM applications in the industry.

AtScale launches public leaderboard for Text-to-SQL, offering a standardized framework to enhance transparency, competition & collaboration in T2SQL.