, PERIOD FOR SYSTEM_TIME (valid_from, valid_to) ) WITH (SYSTEM_VERSIONING = ON (HISTORY_TABLE = HumanResources.EmployeeHistory)); Once defined, SQL Server will automatically keep up with the rest.

It can build WHERE clauses, perform JOINs across multiple tables, and use built-in SQL functions to perform translations on the SQL side to streamline the mapping experience.