BETWEEN for range filtering

Concepts: sqlBetween

What BETWEEN does It keeps range logic concise, especially when both bounds are constants or parameters. Combining Multiple Ranges Multi-Range Filtering For date range queries, always consider whether you need inclusive or exclusive boundaries because including midnight on the last day can pull in unexpected records.