Feature Request: Application-Time Periods

MariaDB supports this feature that a potential customer uses:

https://mariadb.com/kb/en/application-time-periods/

Mariadb has it built in with application period constraints.

Postgres you can do the same thing fairly easily with btree gist https://stackoverflow.com/questions/62392003/postgres-best-way-to-avoid-overlapping-ranges-with-other-conditions

Mysql you have to do a bit annoying trigger: https://www.avaitla16.com/restricting-overlapping-time-periods-in-mysql

The issue names no repository files, tests, or entry points. Start by reading the MariaDB application-time-periods reference and the linked PostgreSQL and MySQL approaches, then inspect Dolt's existing SQL constraint support. Done would require an agreed scope for application-time periods and corresponding behavior and tests.

Written by the indexing model from the issue text.