Getting better at SQL with ChatGPT or: the lazy mode for complex queries.

As I mentioned previously, ChatGPT is quite good (but not only at) at SQL. I think its a great opprotunity to really learn to code (if you want to call SQL querying „coding“ but that’s another discussion). I mean, only this information is SO valuable, I would have searched stackoverflow for hours finding the reason for my SQL bug:

I now can change the query or update mysql.

So here is my lazy setup to create complex SQL queries:

  1. I am using the graphical query builder of metabase for all the complex joining of data

2. I then review the result and convert the results to SQL.

3. For the lazy mode I then paste the sql to ChatGPT, and asking it to add modifications, adjust it – and all in natural language.

Schreibe einen Kommentar

Deine E-Mail-Adresse wird nicht veröffentlicht. Erforderliche Felder sind mit * markiert

Diese Website verwendet Akismet, um Spam zu reduzieren. Erfahre mehr darüber, wie deine Kommentardaten verarbeitet werden.