Quite a few folks are working it actually https://star-history.com/blog/text2sql
LLMs and SQL
11–12 of 12 posts
Re: LLMs and SQL
#12It is really that difficult.
Plus, it helps to have a neck to wring when it turns out that a slightly wrong left join deep in the data reporting pipeline means that you just told the CEO/Board/Wall Street materially incorrect numbers...
Also the part about data analysis is understanding the data and any nuances. Databases tend to be the place where all of an organization's pathologies over time get encoded, so sometimes column names mean a totally different thing then their name, and it's stupid, but it would take too much politics to change so nobody does, and updating the documentation would mean admitting the work around so it's all informally passed around amongst the analysts...