* The old implementation produced invalid SQLite statements for tables with
  a composite primary key, as SQLite cannot have more than one primary key
  clause and autoincrement can only be declared on a single column
* There is currently no way to tell from its pragma if an SQLite column
  auto-increments, therefore enabling it on all primary keys is not accurate
* SQLite primary keys auto-increment anyway (but slightly differently from an
  actual auto-increment column -- not guaranteed unique)

DDC-1337 - MySQL commits transaction on DROP TABLE, need DROP TEMPORARY TABLE. Added tests, looks like oracle commits transactions on CREATE TEMPORARY TABLE. I dont know how to fix it.