I have built some medium sized systems using Microsoft Orleans (Virtual Actors). There was no transactional database involved, but everything was ordered and fully transactional.

If you choose say Cosmos DB, MongoDB or DynamoDB as your persistence provider you can even query the persisted state.

https://learn.microsoft.com/en-us/dotnet/orleans/grains/grai...

https://learn.microsoft.com/en-us/dotnet/orleans/grains/tran...

https://learn.microsoft.com/en-us/dotnet/orleans/grains/even...