Timescale is what you want to go with in case of RDMSes with audibility in terms of change management over time.

It is the THING.

Thanks the timescale team for making this happening!