Temporal Tables
Temporal Tables are a database feature that automatically tracks the full history of data changes in a table, allowing users to query data as it existed at any point in time. They maintain a system-versioned history table that stores all previous versions of rows, with timestamps for when changes occurred. This enables time-based data analysis, auditing, and point-in-time recovery without manual logging.
Developers should use Temporal Tables when building applications that require audit trails, compliance with data retention policies, or the ability to analyze historical trends. They are particularly useful in financial systems, healthcare records, and e-commerce platforms where tracking data changes over time is critical. This feature simplifies implementing temporal queries and reduces the need for custom history-tracking logic.