DBD::SQLite 0.11 is now on CPAN. This upgrades to SQLite 2.4.0, adding views and a few other niceties. I also had to fix the transaction model because running under mod_perl with Apache::DBI it continuously locked up solid. This was because under AutoCommit=0, I would immediately do a "BEGIN TRAN", which locked the database, and even when I issued a commit, it would do "COMMIT TRAN" followed by another "BEGIN" immediately. So now it only does "BEGIN TRAN" when you actually execte some SQL, and just flags whether I'm in a transaction or not. I believe this is how DBD::Sybase does it too.
I also found a couple of bugs in the core SQLite library, which I mailed the author about and he said he'd fix them in the next release (they're nothing major - just cause compiler warnings).