in reply to SQL WHERE clauses with DBIx::Class, using NOT and IN

From SQL::Abstract, I also learned how SQL expressions can be used for INSERT and UPDATE statements. For example, 
   $row->update({end => ['CURRENT_TIMESTAMP']});

[download]
uses the CURRENT_TIMESTAMP register of a DB2 database.

In Section Seekers of Perl Wisdom