I also understood that, but seems unreasonable to be able to achieve it without somehow storing the state via scd or some sort of audit + multi engine support
Sure it's a complex, difficult feature. But that's what "time travel" typically means in terms of querying databases. It's the headline of this article, the fact that what they really mean is a simple query log, is kind of bait-and-switch.