How to extract all the conditions inside a where

[thebruuu]

Hello
I am not able to export the where conditions

If I have a select * from X where (A=1 orB=2) and C=3
I would like to get (A=1 and B=2)
C=3

or at least
A=1
B=2
C=3

Hw should I proceed ?
W ith for i in ast.args["where"].find_all(exp.Expression):
print(i)
I get too many things ...

[georgesittas]

Perhaps something like this works, at least if your WHERE filters are in normal form (either CNF or DNF):

>>> import sqlglot
>>>
>>> ast = sqlglot.parse_one("select * from X where (A=1 or B=2) and C=3")
>>> for cond in ast.args["where"].this.flatten():
...     print(cond.sql())
...
A = 1 OR B = 2
C = 3

[thebruuu]

Thank You very much
Your library is great and it's saving me a lot of time !

THANK YOU