It’s exactly what transactions are for. A nested transaction is called a savepoint, which sqlite does support.