Yes they do! Apparently I was replying to your question while you were replying to mine. :)
I have been playing with the triggers and they work for the most part. The main problem I am having with them in this situation is that they are not called in the search methods of CDBI. So for instance I can't do something like this:
my $obj MyModule->search(password => 'blahblah');
Because the trigger for 'select' hasn't been called so it is literally checking the string 'blahblah' against the encrypted password in the database. :/