[sqlite] nested transactions?

[Kervin L. Pierre]

Hello again,

Are there plans for supporting nested transactions
in the future?  Would that be a difficult extension
to code ( eg. if one thought they could give it a
try :) )

The current restriction makes it hard to use SQLite
in developing a API eg....

exposed_func1()
{
   sqlite3_exec("BEGIN");

   [...do stuff...]

   func2();

   sqlite3_exec("END");
}

exposed_func2()
{
   sqlite3_exec("BEGIN");

   [...do stuff...]

   sqlite3_exec("END");

   [...do more stuff...]

}

I could commit early, eg. before calling expose_func2(),
but on error the entire function needs to be rolled back,
both inner and outer functions.

Any information and, or insight would be appreciated.

-
Kervin