TECH NEWS

What 46,000 Production Queries Taught Us About LLM-Generated SQL

We run a financial data server that sits on top of a 31-million-row DuckDB database. Users connect an LLM (usually Claude), ask questions in plain English, and the model generates SQL against our schema.

Over six months we logged every query: the user's natural language prompt, the SQL the LLM produced, whether it succeeded, how long it took, and how many rows came back. 46k queries total.

Here is what we found.

The database

The database covers 64 years of US stock market data across 12 tables: daily prices and volume (31M rows), quarterly and yearly financials, daily valuations, 56 technical indicators, SEC filing metadata, insider transactions, analyst estimates, and company reference data. About 9,971 securities (stocks and ETFs) on NYSE and NASDAQ.

Users connect to it via MCP (Model Context Protocol), the open standard that lets LLMs call external tools. When a user asks "show me US stocks with...

Copyright of this story solely belongs to hackernoon.com. To see the full text click HERE

https://platform.theverge.com/wp-content/uploads/sites/2/2025/09/STK466_ELECTION_2024_CVirginia_E.jpg?quality=90&strip=all&crop=0%2C9.9676601489831%2C100%2C80.064679702034&w=1200

Trump and Mike Johnson think the AI industry is overreacting

Terrence O'Brien is the Verge’s weekend editor. He’s covered the tech industry for over 18 years and knows a thing or two about synths. Yesterday, Anthropic CEO Dario Amodei published a lengthy open letter saying it was time to “pace the frontier” and slow down AI

https://media.thenextweb.com/2026/09/Barack-Obama-on-stage-at-The-O2.jpg

Obama warns AI in private hands could be dangerous and urges Democrats to act

Barack Obama told a closed Democratic fundraiser last Thursday that artificial intelligence is “moving very fast in private hands, and if we don’t get on top of it, I think it can be dangerous”. The New York Times obtained a partial transcript from his office and reported the remarks

https://media.thenextweb.com/2026/06/zhipu-ai-office.jpg

Z.ai raises $5bn in Hong Kong including $3bn of zero-interest bonds

Z.ai, the Chinese model developer listed in Hong Kong as Zhipu, has raised about $5bn in a single move. Roughly $2bn came from placing 21.97 million new shares at HK$714, about 10 percent below the previous close. The other $3bn came from RMB 20.14bn of convertible

https://techcrunch.com/wp-content/uploads/2026/09/GettyImages-2233466982.jpg?resize=1200,821

What’s behind the AI industry’s latest warnings of doom?

The AI industry seems to be having its loudest debate yet about whether its technology poses an existential threat to humanity. The current discussion began after AI researcher Jacob Coxon said that he’s resigned from Anthropic because he’s worried that the leading AI companies are “gambling with our

The database

Read more

Trump and Mike Johnson think the AI industry is overreacting

Obama warns AI in private hands could be dangerous and urges Democrats to act

Z.ai raises $5bn in Hong Kong including $3bn of zero-interest bonds

What’s behind the AI industry’s latest warnings of doom?