Here I was planning the usual ADR singing praises to PostgreSQL... but not this time. I finally found one reason to use SQL Server instead of the goat. I'm actually surprised @PostgreSQL support for bitemporal data is non-existing. Image is SQL Server.