Metadata
- Author: Counting Stuff
- Full Title:: Doing SQL Work With LLM Aids as a SQL Addict
- Category:: 🗞️Articles
- Document Tags:: Text To Sql,
- Read date:: 2025-07-30
Highlights
In many situations, if I had all that information at my fingertips already, I would be most of the way there to writing the query myself. With all the logic and schema at my fingertips, the only remaining barrier is syntax and aside from dialect-specific quirks, SQL syntax isn’t that difficult. It honestly would take more natural language words to describe the query I want than the actual query itself. (View Highlight)
Overall, I really dislike this entire use case unless somehow these systems manage to pull in the context without your intervention. (View Highlight)
Given the length of the queries, the length of any schema context I’m providing, and all the interconnected context needed to write SQL (because the clause order requires bouncing back and forth), LLMs are surprisingly weak at this task. I suppose if a query is large enough to make my head hurt refactoring, an LLM doesn’t do much better. (View Highlight)