Found in 2 comments on Hacker News
_boffin_ · 2022-11-04 · Original thread
If anyone is looking for a good book on this subject, check out https://www.amazon.com/Developing-Time-Oriented-Database-App...
_boffin_ · 2022-05-09 · Original thread
- Bitemporal Databases: Modeling and Implementation: https://www.amazon.com/Bitemporal-Databases-Canan-Eren-Atay/...

- Developing Time-Oriented Database Applications in SQL by Rich. Snodgrass: https://www.amazon.com/Developing-Time-Oriented-Database-App...

-----

Anything by Joe Celko:

- SQL for Smarties: https://www.amazon.com/gp/product/B00R17NZZC

- SQL Programming Style: https://www.amazon.com/gp/product/B006L21AO6

- Trees and Hierarchies in SQL for Smarties: https://www.amazon.com/gp/product/B006Y8MKUU

- Thinking in Sets: https://www.amazon.com/gp/product/B001AODZZC

-------

- SQL Antipatterns by Bill Karwin: https://www.amazon.com/SQL-Antipatterns-Programming-Pragmati...

Fresh book recommendations delivered straight to your inbox every Thursday.