Here is a list of things that the core SQLite developers
want to work on in the near future:

*: 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