It's the basis behind Datomic, if I'm not mistaking.

You can easily search through history. The point is, it is better to do this in the design of the database than in the design of the schema.

So: "No?" -> "Yes!"

Okay, but for something like SQL this seems like a bad idea.