There are a number of benefits to using xPDO instead of writing SQL directly against the database.
I’ve restarted work on SQLite support for xPDO, and things are looking good so far. This will be targeted at PHP 5.2’s PDO driver for SQLite3, not the older sqlite2 PDO driver included with PHP 5.1.x that is no longer available via PECL. It may be easily adaptable however.