[Investigate] Improving performance on `date.<duration>`

Community issues:
- https://github.com/influxdata/influxdb/pull/22538
- https://community.influxdata.com/t/influx-2-0-performance-versus-influx-1-7-on-windows/20887

It seems Dan had thought pushing this filter down would do the trick. Does InfluxQL against 1.X have this effectively pushed down?

Start by reading the linked pull request #22538 and the referenced InfluxDB community report. Compare how InfluxQL in 1.X handles this filter and investigate whether pushing the filter down improves date. performance. Done means reaching and documenting a clear implementation or non-implementation conclusion.

Written by the indexing model from the issue text.