Class::ReluctantORM::Driver::SQLite - SQLite driver for CRO
# See Class::ReluctantORM::Driver
Supports any version of sqlite supported by DBD::SQLite.
SQLite is itself fairly idiosyncratic. Here are how they impact this driver:
- No RETURNING support on INSERT/UPDATE/DELETE
Since SQLite doesn't support this SQL extension, and DBD::SQLite doesn't support using output binds to read them (a hack the Oracle DBD provides), you can't use RETURNING to get columns from INSERT/UPDATE/DELETE statements you provide in SQL, nor can you add output columns to SQL objects performing those operations. Worse, if your model uses refresh_on_update columns, they must be fetched by a separate SELECT (handled internally by the Driver, but you need to be aware of the penalty).
- Column names forced to be lowercase