It seems to be using Zend_Db for data base management layer. I think better using multiple support database for piwik. SQLite is better that any one. Portable and fast.
SQLite support is not being planned as it is deemed out-of-scope. However, feel free to discuss on the mailing list and/or submit a PR.