[1] is an great research paper about supporting temporal data in SQL. It goes beyond the SQL:2011 standard to support temporal outer joins and some other things

[1] is an great research paper about supporting temporal data in SQL. It goes beyond the SQL:2011 standard to support temporal outer joins and some other things. Basically they define a temporal variant for each relational operator then show how to implement them all based on just two join-like additions to SQL. They even implemented a proof-of-concept in Postgres. I wrote some more about their paper in my temporal databases bibliography [2] (ctrl-f "Alignment"). The paper is easy to read & understand, and it solves problems people have been working on since the 90s, with the most elegant solution I've seen. [1] https://files.ifi.uzh.ch/boehlen/Papers/modf174-dignoes.pdf https://files.ifi.uzh.ch/boehlen/Papers/modf174-dignoes.pdf [2] https://illuminatedcomputing.com/posts/2017/12/temporal-databases-bibliography/ https://illuminatedcomputing.com/posts/2017/12/temporal-data...