I want to ask why the query builder class does not included NOT BETWEEN.

The hack I tried was this:

->where('"mytable.date" not between '." $min_date ".' AND '. "$max_date")

It built this WHERE condition:

"mytable"."date" "not" between "2017-5-18" AND 2017-6-7

How can I effectively used this with CodeIgniter's query builder class ?

I am using the postgresql driver.