- PHP 5.3 +
- PHP 5.2 branch
$q->table('test')
->column('test_2', 'test')
->table('test_3', 'test_2');
//=> SELECT test_2 as test FROM test, test_3 AS test_2
$q->table('table')
->begin_and()
->andWhere('col_1', 1)
->orWhere('col_2', 2)
->endAnd()
->orWhere('col_3', 3, '!=');
//=>SELECT * FROM table WHERE ( col_1 = '1' OR col_2 = '2' ) or col_3 != '3'
$q->table('table')
->beginAnd()
->beginAnd()
->andWhere('col_1', 1)
->orWhere('col_2', 2)
->endAnd()
->endAnd()
->orWhere('col_3', 3, '!=');
//=>SELECT * FROM table WHERE ( ( col_1 = '1' OR col_2 = '2' ) ) OR col_3 != '3'