Drupal db abstraction layer

I get this with SQLite when installing the module:

PDOException: SQLSTATE[HY000]: General error: 1 no such function: UNIX_TIMESTAMP: INSERT INTO {user_revision} (uid, vid, log, timestamp, authorid, name, mail, theme, signature, signature_format, status, timezone, language, picture, data) SELECT u.uid, u.vid, '', UNIX_TIMESTAMP(), u.uid, u.name, u.mail, u.theme, u.signature, u.signature_format, u.status, u.timezone, u.language, u.picture, u.data FROM {users} u WHERE u.vid=0 AND u.uid <> 0; Array ( ) in user_revision_enable() (line 41 of ../sites/all/modules/contrib/user_revision/user_revision.module).

This is because SQLite does not know UNIX_TIMESTAMP().

All db_query() calls should be rewritten to use db_select(), db_insert() or something like that.