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:
- 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.