"WHERE column IS NOT NULL" with Kohana v3 Query Builder

Question

Is it possible with Kohana v3 Query Builder to use the IS NOT NULL operator?

The where($column, $op, $value) method requires all three parameters and even if I specify

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

it builds and invalid query eg.

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

Answer 1

The operator is not escaped:

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

No need to use DB::expr, Kohana already supports what you want.

Answer 2

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

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