Rolling windows for clickhouse

**Is your feature request related to a problem? Please describe.**
I want to use rolling windows in clickhouse but I cannot get them to work when applying a granularity. Looking at the tests running for clickhouse I guess this is not supported?

**Describe the solution you'd like**
Rolling windows work with granularity applied.

**Describe alternatives you've considered**
At least document that it is not supported so people don't lose time. Perhaps include an alternative.

**Additional context**
Ref. https://github.com/cube-js/cube/blob/eab3ce906e1b0af1551057b567d01d96b635ed01/packages/cubejs-schema-compiler/test/integration/clickhouse/custom-granularities.test.ts#L329

I think this support is now there, ref. https://clickhouse.com/docs/sql-reference/statements/select/join#join-with-inequality-conditions-for-columns-from-different-tables

For this you need join_use_nulls=0, which cube does when clickhouse is readonly