Nested Where Clause

[deepsweech]

Is there a possibility to support such criteria?

WHERE
(cond1 = 1 OR cond2 = 1)
AND
(cond3 =1 OR cond4 = 1)
...

Criteria.all ([Criteria.any([x]) ])

[Bohdan-Ilchyshyn]

from pypika import Field
from pypika.terms import Criterion

criteria = Criterion.all((
    Criterion.any((
        Field('test_field') == 'test_value1',
        Field('test_field') == 'test_value2',
    )),
    Criterion.any((
        Field('test_field2') == 'test_value3',
        Field('test_field3') == 'test_value4',
    )),
))

print(criteria.get_sql())

"""
Result:
("test_field"='test_value1' OR "test_field"='test_value2') AND ("test_field2"='test_value3' OR "test_field3"='test_value4')
"""