←back to thread

Getting AI to write good SQL

(cloud.google.com)
478 points richards | 1 comments | 16 May 25 21:10 UTC | HN request time: 0.228s | source
Show context
rectang ◴[17 May 25 00:04 UTC] No.44010899[source]▶
> We will cover state-of-the-art [...] how we approach techniques that allows the system to offer virtually certified correct answers.

I don't need AI to generate perfect SQL, because I am never going to trust the output enough to copy/paste it — the risk of subtle semantic errors is too high, even if the code validates.

Instead, I find it helpful for AI to suggest approaches — after which I will manually craft the SQL, starting from scratch.

replies(4): >>44011204 #>>44011349 #>>44011379 #>>44011432 #
hsbauauvhabzb ◴[17 May 25 01:36 UTC] No.44011379[source]▶
Explain that to the average manager or junior engineer, both who don’t care about your desire to build well but not fast.
replies(2): >>44011448 #>>44011772 #
1. rectang ◴[17 May 25 03:14 UTC] No.44011772[source]▶
It’s not true that I want to build “well but not fast” — I’m trying to add value, and both speed and reliability matter. My productivity is high and I don’t have trouble articulating why; my approach has generally (though not universally) been well received by management and colleagues.