- SAVEPOINT and nested transactions
- Enforce foreign key constraints.
- Omit support for deferred constraints
- Omit support for CASCADE
- Rewrite the VDBE to be a 3-address machine rather than a stack-based machine
- Use merge-sort like algorithms to make large inserts into indexed tables run faster