Need is or i NULL operator for where clause

[zzzeek]

Originally reported by: Anonymous

---

Subj. sql operators =, in and others don't take me need results if I want to write something like

select * from tbl where col is NULL;

I can use instead op method from CompareMixin but I think explicit null check will be good solution

---

• Bitbucket: https://bitbucket.org/zzzeek/sqlalchemy/issue/187

[zzzeek]

Original comment by Michael Bayer (Bitbucket: zzzeek, GitHub: zzzeek):

---

this has always been available like the following:

    table.select(table.c.column == None)

which creates an IS NULL clause.

however, it probably wasnt documented so clearly. so in changeset:1496, changeset:1497, i added a doc for it. you can also do

   table.select(table.c.column == null())

now.