←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.205s | source
Show context
tango12 ◴[16 May 25 23:05 UTC] No.44010584[source]▶
What’s the eventual goal of text to sql?

Is it to build a copilot for a data analyst or to get business insight without going through an analyst?

If it’s the latter - then imho no amount of text to sql sophistication will solve the problem because it’s impossible for a non analyst to understand if the sql is correct or sufficient.

These don’t seem like text2sql problems:

> Why did we hit only 80% of our daily ecommmerce transaction yesterday?

> Why is customer acquisition cost trending up?

> Why was the campaign in NYC worse than the same in SF?

replies(5): >>44010646 #>>44010660 #>>44010746 #>>44010772 #>>44011353 #
1. mynegation ◴[16 May 25 23:18 UTC] No.44010660[source]▶
To be fair, these don’t look like SQL problems either. SQL answers “what”, not “why” questions. The goal of text2sql is to free up analyst time to get through “what” much faster and - possibly- focus on “why” questions.