Temporal tables, aka system versioned tables, are something like this: https://mariadb.com/kb/en/system-versioned-tables/