When you work with the DSQL, you can work with transactions. There are 2 enhancements to the standard functionality of transactions in DSQL:
- You can start nested transactions.
- You can use :php
Connection::atomic()which has a nicer syntax.
It is recommended to always use atomic() in your code.
Warning
If you roll-back internal transaction and commit external transaction, then result might be unpredictable. Please discuss this atk4/dsql#89