When I use the Analysis builder UI to specify query filter using the value "0", the WHERE clause disappears.
See the below screenshots as example:
It works fine for value other than "0"
But the WHERE clause just disappear when I use "0", which is also a legit filter