Active Record does not support parentheses

[Shadowhand]

Active Record should support queries like:

SELECT * FROM `table` WHERE (`foo` = 1 AND `bar` = 5) OR (`foo` = 3 AND `bar` = 7);

Syntax will have to be decided.

[zombor]

I propose this AR code:

$this->db->from('table')->where('a', 1)->where(array('b' => 2, 'c' => 3), 'or')->orwhere('d', 4);

makes:

SELECT * FROM 'table' WHERE `a` = 1 AND (`b` = 2 or `c` = 3) OR `d` = 4;

[gregmac]

What value is there doing this vs just specifying the WHERE clause in SQL? SQL seems more readable and predicable

[JAAulde]

Greg, the value in this is to avoid writing any SQL which really is the is the purpose of Active Record. And avoiding as much manual SQL writing as possible helps prevent injection.

[zombor]

This is not really a bug, but an enhancement to the current AR syntax, so I'm changing it as such.