Indeed. Better temporal support was added the ANSI SQL 11 standard[0] and it is supported by a number of databases, some (like Postgres) by extensions and others (like SQL Server) natively[1].

[0] https://en.wikipedia.org/wiki/SQL:2011

[1] https://docs.microsoft.com/en-us/sql/relational-databases/ta...