Transactions

$transaction = \Yii::$app->db->beginTransaction();
try {
\Yii::$app->db->createCommand($sql)->execute();
\Yii::$app->db->createCommand($sql)->execute();
//[ ... more queries ...]
$transaction->commit();
} catch (\Exception $e) {
$transaction->rollBack();
}