Solar_Sql begins in auto-commit mode, which means that all queries are committed to the database as they are executed.
If you want leave auto-commit mode and start a transaction, call Solar_Sql_Adapter::begin(). Then, after you save the transaction using Solar_Sql_Adapter::commit() or cancel it using Solar_Sql_Adapter::rollback(), Solar_Sql returns to auto-commit mode until you begin another transaction.