Hacker News new | ask | show | jobs
by fwungy 951 days ago
SQL seems like a perfect candidate for AI support.

> Join the tables foo and bar on bar_id and bar and baz on baz_id and select quip that begins with 'it' or ends with 'qu' but does not have numbers, for oracle, using date format mm/dd/yyyy.

2 comments

We tried with ChatGPT, if you throw enough context(Database Schema) to it, it will be able to find the relationship in the tables and generate the join correctly. And for date format, yeah, if you don't specify it, you won't get what you want in some cases.
AI support also works great for generating code that uses ORMs.