Appending condition to existing WHERE clause

[dibsonmuad]

Hi!
I have a sql query like this: SELECT t.a, t.b FROM t WHERE t.c = "blah" GROUP BY .... I can parse the where clause with parse_one(sql_string).find(exp.Where). However, can you point me to the doc or give an example how to add an and or or condition to an existing WHERE section?

Thanks!

[tobymao]

You can just call where on the select statement.

>>> parse_one("select * from x where y = 'blah' group by x").where("z = foo").sql()
"SELECT * FROM x WHERE y = 'blah' AND z = foo GROUP BY x"

this defaults to AND, if you want to rewrite the Where, you can do

>>> parse_one("select * from x where y = 'blah' group by x").where("z = foo or y = 'blah'", append=False).sql()
"SELECT * FROM x WHERE z = foo OR y = 'blah' GROUP BY x"

[dibsonmuad]

Very nice! Thank you!