Dev: DB transactions after v4.3

We need to discuss:

- [x] Allow manual DB transactions even when `DBDebug` is true.
- #6917
- `DBDebug` will be deprecated in the future if possible.
- Perhaps this setting should not be eliminated.
- This setting is widely used and needs a long period of time before removing it.
- [ ] Add `resetTransStatus()` method ?
- #8767
- [ ] Model validation error and transaction. See https://forum.codeigniter.com/showthread.php?tid=84887&pid=403200#pid403200

See https://github.com/codeigniter4/CodeIgniter4/pull/6886#issuecomment-1325774111, https://github.com/codeigniter4/CodeIgniter4/pull/6886#issuecomment-1324182519

检查关于 resetTransStatus() 和使用事务进行模型验证的未解决清单项，然后阅读相关 issue #6917 和 #8767 以及所引用的 pull request 讨论。此 issue 未定义 Done，因为它合并了多个仍需决策的事务策略问题。

由索引模型根据 Issue 内容生成。