Filters does not produce good sql

Currently the filters does not work because of not correct sql

SELECT node.nid AS nid, node.sticky AS node_sticky, node.created AS node_created FROM {node} node WHERE (( (node.promote <> 0 = :db_condition_placeholder_0) )

The current views_handler_filter_boolean_operator does not use value and operator for where(). it would be possible to do it,but
there has to be a way to add custom sql to where.

So i thought if there is no operator and no value added it should be used $query->where instead of $query->condition, here is a patch for it.
This does definitive needs review, i don't know how the where part is planned, what should be supported etc.