Today, I had need of the ability to use 2 sets of paranthesis in a query and couldn't.

I needed to find ((Gift Date X AND Campaign Y) OR (Gift Date X & Campaign Q)) AND (Constituent Code AA).

This isn't the first time I've come across this situation, but this is the first time I couldn't use the merge query function to solve my issure, because I needed it to stay as a dynamic query.

I ended up having to create 2 subsets both using all 3 criteria, which took me ages to setup.