One of these Postgres-based implementations of SQL:2011's temporal versioning might get you close enough:

- https://github.com/nearform/temporal_tables

- https://github.com/xocolatl/periods

- https://github.com/scalegenius/pg_bitemporal

- https://github.com/arkhipov/temporal_tables

I haven't used any of them but I work on https://xtdb.com which is also implementing SQL:2011's temporal features :)