You could get that result by doing a <code>BEGIN IMMEDIATE</code> and never closing the transaction. Just use savepoints for what should be transactions. Of course, other connections won't see your changes. But in this situation I'm not sure you'd want them to.