i found possible bug in select. Code for reproduction is:
$empty = array();
$connection->table("foo")->select("*")->where("(id NOT IN ?)",$empty);
Badly generated SQL is: SELECT * FROM foo WHERE
((id NOT IS NULL AND FALSE))
@duke: what? I thing your code doesn't solve anything.
@priman: correct solution, but you probably know it and you are just
$connection->table("foo")->select("*")->where("(id NOT ?)", );
@hrach My bad. I thought
@priman's use of brackets was different than
Nette\Database requires and didn't notice it was the IN operator that confused
I am removing my previous comment.