SQLite Forum

cannot start a transaction within a transaction using sqlite shell
You are correct that I should have been talking about sqlite connection objects, not processes.  However, in this specific case, I think there is a one-to-one mapping between the two, since each invocation of the sqlite shell is associated with a single connection object.