Can I use just the Doctrine DBAL to write portable database code (works across MySQL, SQLite,...

I'm trying to write an open source application that will work with multiple database vendors (SQLite for small installations, MySQL/Postgres for larger). I'd love to use the Doctrine DBAL for this, but the documentation implies that the queries it generates are not actually portable and I would need another library to handle the differences between the database systems.

I've been using illuminate/database, a standalone version of Laravel's query builder, but I'm wondering if there are other options I don't know about or if I'm misunderstanding the Doctrine docs. I'd prefer not to use a full ORM; I don't mind writing verbose PHP to build portable queries, but I don't want to abstract away the queries themselves.

Continue reading...