←back to thread

Getting AI to write good SQL

(cloud.google.com)
478 points richards | 3 comments | 16 May 25 21:10 UTC | HN request time: 0s | source
1. antman ◴[17 May 25 00:38 UTC] No.44011097[source]▶
This is on howto to to write good SELECTS, not SQL. AI is good enough to also create schemas from spec, migrate, explore databases, testing etc which tgis article does not touch upon
replies(1): >>44011190 #
2. TechDebtDevin ◴[17 May 25 00:56 UTC] No.44011190[source]▶
Every time I've fed more than 5 migration files and asked Claude to make multiple across those files it fails, it does very badly in almost all cases, even on kinda basic schemas. I actually don't think LLMs grok complex migration files or sql that well at all.
replies(1): >>44011570 #
3. fooker ◴[17 May 25 02:23 UTC] No.44011570[source]▶
Well that's a great startup idea if you're familiar with the domain.