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.
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);