I've been reading with interest about SQL Server 2016's Temporal Table capability.
It almost seems like the answer to a problem I have (and I'm sure many have had), except for one thing:
StartTime and EndTime durations are immutable.
Which is great for transactions going forward...but what if you want to model stuff that changed in the past?
Is it possible to model things like "Organization A was named X between 1970 and 1980, Y between 1980 and 1990, and Z since 1990" using temporal tables? Or are we stuck with traditional methods for this stuff?
It looks to me like temporal tables are only good with changes that happen after the temporal table is created, but I'd like someone to confirm or deny that. (Bonus points if my assumption is correct and you can point me to something that describes the ideal way to implement tables and queries to handle historical queries.)