←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.421s | source
Show context
bob1029 ◴[17 May 25 00:20 UTC] No.44010995[source]▶
For the problems where it would matter the most, these tools seem to help the least. The hardest problem domains don't have just one schema to worry about. They have hundreds. If you need to spin up a personal blog or todo list tracker, I have no doubt that Google, et. al. can take you exactly where you want to go.
replies(1): >>44011116 #
1. galenmarchetti ◴[17 May 25 00:43 UTC] No.44011116[source]▶
and then add in ambiguity in the business terms / intention behind the query. still a big need for something like semantic layer or ontology to sit between business and at least right now that stuff hasn’t been automated away yet (it should be though)
replies(1): >>44011396 #
2. mrtimo ◴[17 May 25 01:40 UTC] No.44011396[source]▶
Malloy [1] has a semantic layer [2]... and Model Context Protocol (MCP) support is being added through Publisher [3]. Something to keep an eye on. Seems like a great fit for LLMs.

[1] https://www.malloydata.dev/ [2] https://docs.malloydata.dev/documentation/user_guides/malloy... [3] https://github.com/malloydata/publisher