Getting AI to write good SQL

Wait... people need AI to write SQL ?

Most people here have not understood the relational model, so yes.

I’ve read most of Codd’s book on the subject and have written SQL on and off since the mid 90’s and I still need to look up the differences between the various joins anytime I use them.

A junior in SQL would need AI to write things they're not sure about, the same way stackoverflow has helped us for many many years before AI. A senior in sql, and in fact any languages, would use AI to be accelerated (I know I do).

no.but if I ask for a report in natural language, the AI needs to be able to write sql.

I see this comparison too often and I don't think it's fair. Stackoverflow has peer review.

Ok, but you did get the general concept of why it is better than a hierarchical file storage system.

I also assume you dont try to throw mongoDB on every problem where a SQL database is clearly superior.

It's a fair statement. Good point.