Comment by flowerlad

What model are you using? I find Claude Sonnet to be quite capable of generating correct queries. Also, are you using a semantic layer [1], because without it the model may have trouble understanding your schema. I would be very surprised if you PM gets a wrong answer with these settings. I have never seen Sonnet 4.6+ produce a bad query.

[1] https://communitysupport.group/t/what-is-the-purpose-of-the-...