Ranges can be used in filters with the in function, with any type of literal, including dates:

As discussed in the take docs, ranges can also be used in :

PRQL

SQL

Half-open ranges are generally less intuitive to read than a simple >= or operator.