https://softwarepatternslexicon.com/sql/advanced-sql-patterns/temporal-and-bi-temporal-data/