Search Builder in CiviCRM allows groups of AND statements to be connected by OR statements, but not the other way around.
That is, I can perform a search like:
(X AND Y AND Z) OR (A AND B AND C)
(X OR Y OR Z) AND A AND B AND (C OR D).
If I want to do the latter, I have to rewrite the entire query for each of the elements in the OR statements. That gets pretty tedious pretty quickly.
My questions are:
Why is it like this?
Is there some way to search (within CiviCRM with all the benefits and options for search results) as per my second example?