fix(schema-compiler): (backporting) return granularity-truncated queries in client time zone

[KSDaemon]

This is a backport of https://github.com/cube-js/cube/pull/8877

Check List

• [x] Tests has been run in packages where changes made if available
• [x] Linter has been run for changed code
• [x] Tests for the changes have been added if not covered yet
• [ ] Docs have been added / updated if required

[vercel[bot]]

The latest updates on your projects. Learn more about Vercel for Git ↗︎

8 Skipped Deployments

| Name | Status | Preview | Comments | Updated (UTC) | | :--- | :----- | :------ | :------- | :------ | | **examples-angular-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-angular-dashboard/DMnMEYN6ccD74NafPDX44CWeimdZ)) | [Visit Preview](https://examples-angular-dashboard-git-fix-granularitie-2a954d-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-d3** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-d3/4hYGyvvC2DLiBGYPJVig97H8gQVt)) | [Visit Preview](https://examples-react-d3-git-fix-granularities-timezones-v1-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-dashboard** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-dashboard/BzxXmXGmvVFMs1bGe7R8VjxoGMpE)) | [Visit Preview](https://examples-react-dashboard-git-fix-granularities-3cccb4-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-data-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-data-table/Dx7Jx6hRUdE4Z8biHZBfqmZisrwM)) | [Visit Preview](https://examples-react-data-table-git-fix-granularities-5dc183-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-highcharts** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-highcharts/FFoNSQxQVBqmgkqXycStPu9FPiZg)) | [Visit Preview](https://examples-react-highcharts-git-fix-granularities-0eff83-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-material-ui** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-material-ui/HndkvYCr8Hw8o1oLLVbN9W85yM5F)) | [Visit Preview](https://examples-react-material-ui-git-fix-granularitie-013411-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-react-pivot-table** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-react-pivot-table/A9VigPRpJ6d6r3UFfbfbSF46bmis)) | [Visit Preview](https://examples-react-pivot-table-git-fix-granularitie-c673b4-cube-dev.vercel.app) | | Oct 29, 2024 0:16am | | **examples-vue-query-builder** | ⬜️ Ignored ([Inspect](https://vercel.com/cube-dev/examples-vue-query-builder/6M8BvbmJQEkfc9WEk5i4d3RJwhgM)) | [Visit Preview](https://examples-vue-query-builder-git-fix-granularitie-8b6949-cube-dev.vercel.app) | | Oct 29, 2024 0:16am |