This isn't a required design to achieve transactional consistency. See for example how this would be done in Erlang - single connection dispatching to isolated

This isn't a required design to achieve transactional consistency. See for example how this would be done in Erlang - single connection dispatching to isolated Erlang processes. Fundamentally just needs isolation to be done at a different layer.