Decades ago when I learned databases it was confusing just learning from the SQL but then I used the Microsoft Access query builder which was drag and drop of tables then connecting the table fields to each other with lines, much like how Visio works and that would generate the SQL.
Similar tool, image from here
Would not expect Discourse to create such a tool for building an SQL but might be possible to get the AI to generate such images of the connected tables as feedback.
IIRC in this video it is noted to first create with GPT-4 to get the correct results, then customize for GPT-3.5 for speed.
