Proposal: within time range syntax

[killme2008]

What type of enhancement is this?

API improvement, User experience

What does the enhancement do?

If the user wants to query the rows in a given year, date, or minute currently, they must specify the query conditions such as:

select * from monitors where ts >= '2024-01-01 00:00:00' and ts < '2025-01-01 00:00:00';

select * from monitors where ts >= '2024-04-19 00:00:00' and ts < '2024-04-20 00:00:00';

select * from monitors where ts >= '2024-04-19 23:50:00' and ts < '2024-04-19 23:51:00';

It would be better to provide a syntax sugar that helps users simplify the query:

select * from monitors where ts within '2024';

select * from monitors where ts within '2024-04-19';

select * from monitors where ts within '2024-04-19 23:50';

The predicate [column] WITHIN [TIMESTAMP] that will be transformed into

[column] >= [TIMESTAMP start] and [column] < [TIMESTAMP + 1 interval]

The interval is chosen based on TIMESTAMP precision.

Implementation challenges

No response