Suggestion/Discussion for Active Record WHERE-clause grouping feature

[eluser]jedd[/eluser]
Hi Phil,

This looks like a fantastic idea.

ObDisclaimer - I don't use an ORM, and rarely use the CI AR methods. The latter is partly due to the difficulty of encoding complex queries, such as you're describing here. I keep wanting to migrate back to the fold, so to speak, so anything that helps with that would be very well received.

I have a couple of thoughts:

- 'group' is a pretty overloaded term already (but I can't think of a better one right now!) especially as it has both verb and noun forms
- normal group_start's imply an AND (as per normal CI AR qualifiers) ... is that right?
- I'm wondering if it's too big a goal to try to combine sub-grouping with sub-queries using a similar approach to what you've done here?