FYI you can use Claude (I’m using 3.5 Sonnet) to create quite complex queries. I created a query that gives users a score based upon very specific criteria I gave it. It took a lot of back forth to get it where I wanted, but in the end I’m thrilled with the results, the hardest part is figuring out the criteria to use.
I tried OpenAI and Gemini for this as well, and Claude was the undeniable winner.