I am new to the Axon Framework and the event driven database model. So when the business ask me to run a bit of SQL to just put a patch in the database, you’d think it would be an easy thing to do. However, I am now learning that this is a dangerous thing to do, as the event store knows nothing about these changes, so any replay will just remove them.
So in a live environment what are the options for applying a simple patch to database records? I can see that this could be done in code that generated events, that then updated the database, but that requires a code deployment into a secure production environment.
I would be interested in hearing the solutions that people use to this issue.