Materialized views are what you should be using, not reconstructing the state from the event log every time. That gives you access to SQL and everything to do w

Materialized views are what you should be using, not reconstructing the state from the event log every time. That gives you access to SQL and everything to do with it. And in reality, the event log does live forever in the real world outside of your system. Attributes of your aggregates from last year are still valid for events related to last year, even if they're now deprecated or no longer in use. CQRS/ES is about system design that evolves. It evolves in a much cleaner and easier way if you follow it. Is it perfect? No. There are some gnarly problems related to, for example, GDPR's "right to be forgotten", but that needs to be solved across database backups as well.