Is it feasible with Kohana v3 Query Builder (Kohana v3 being probably the most poorly recorded #$@$%...) to make use of the Isn't NULL operator?

The where($column, $op, $value) method requires the 3 parameters and even when I specify

->where('col', 'IS NOT NULL', '')

it develops and invalid query eg.

SELECT * FROM table WHERE col IS NOT NULL '';

Is a bug? Also -- despite some good advantages (like template remotes along with a nice auth system) Kohana is horribly undocumented. Frustratingly so. Holy F**k. I am wondering whether I ought to go with 2.xx but it is past too far within the project to change. arg.

$frustration++;

The operator isn't steered clear of:

->where('col', 'IS NOT', NULL)

You don't need to use DB::expr, Kohana already supports what you would like.

This works together with the ORM module and is a touch less typing.

->where('col', '!=', NULL);

Unsure (it's 3 AM at this time) but ->where('col', '', DB::expr('IS NOT NULL')) might works.

This will work:

->where('col', '=', NULL);