I found that having a NoSQL distributed database for prod that stream Change Data Captures to a read-only SQL DB to be a great compromise. The SQL data was slightly stale but that wasn't an issue for most situations (like graphing data or certain error metrics)