←back to thread

Getting AI to write good SQL

(cloud.google.com)
478 points richards | 2 comments | 16 May 25 21:10 UTC | HN request time: 0.001s | source
Show context
mousetree ◴[16 May 25 22:02 UTC] No.44010169[source]▶
Out of all the AI tools and models I’ve tried, the most disappointing is the Gemini built into BigQuery. Despite having well named columns with good descriptions it consistently gets nowhere close to solving the problem.
replies(2): >>44010326 #>>44010346 #
flysand7 ◴[16 May 25 22:31 UTC] No.44010346[source]▶
Having written more SQL than any other programming language by now, every time I've tried to use AI to write the query for me, I'd spend way more time getting the output right than if I'd just written it myself.

As a quick aside there's one thing I wish SQL had that would make writing queries so much faster. At work we're using a DSL that has one operator that automatically generates joins from foreign key columns, just like

    credit.CLIENT->NAME
And you got clients table automatically joined into the query. Having to write ten to twenty joins for every query is by far the worst thing, everything else about writing SQL is not that bad.
replies(6): >>44010730 #>>44010752 #>>44011084 #>>44011577 #>>44015959 #>>44020501 #
1. emmelaich ◴[17 May 25 02:24 UTC] No.44011577[source]▶
I'd like there to be a function or macro for a bunch of joins, say

    DEFINE products_by_order AS orders o JOIN order_items oi ON o.order_id = oi.order_id JOIN products p ON oi.product_id = p.product_id
You could make it visible to the DB rather than just a macro so it could optimise it by caching etc. Sort of like a view but on demand.
replies(1): >>44011833 #
2. icedchai ◴[17 May 25 03:32 UTC] No.44011833[source]▶
Sounds like a CTE?