@chaen will discuss with @aldbr
Should handle:
- The normal "transparent" transaction with automatic commit/rollback in a request
- Special cases like the refresh token revocation where we want to commit while also returning an error
- Document how to handle the DB transactions