Has anyone done #bitemporal stuff with postgres 16? I understand SQL:2011 support has landed in postgres 18 but I'm hesitant about upgrading (being very conservative). I'm aware of https://github.com/scalegenius/pg_bitemporal and https://github.com/xocolatl/periods but I'm no database expert and I feel like a baby engineer dipping my toes in. What do y'all recommend?
(I don't want to use #xtdb or #datomic because I know even less about these and I want to be able to maintain what I build)