SQL Temporal Tables Include Current State
Temporal tables support the FOR SYSTEM_TIME syntax. One of its options effectively does the UNION for you. From the documentation:

SELECT * FROM my_table
FOR SYSTEM_TIME ALL;



  ALL   Returns the union of rows that belong to the current and the history table.