Enable two-phase commits if supported by dialect.
Enable foreign key constraints in SQLite for tests