feat(schema-compiler): Reference granularities in a proxy dimension

[KSDaemon]

This PR introduces the ability to reference the time dimension granularity in dimension definition like this:

.....
    dimensions:
      - name: created_at_half_year
        sql: "{created_at.half_year}"
        type: string

      - name: created_at_fiscal_year_feb
        sql: "{created_at.fiscal_year_by_1st_feb}"
        type: string

      - name: created_at
        sql: created_at
        type: time
        granularities:
          - name: half_year
            interval: 6 months
          - name: half_year_by_1st_april
            interval: 6 months
            offset: 3 months
          - name: fiscal_year_by_1st_feb
            interval: 1 year
            offset: 1 month
          - name: fiscal_year_by_15th_march
            interval: 1 year
            origin: '2024-03-15'

      - name: created_at_predefined_year
         sql: "{createdAt.year}"                   # You can refer even predefined granularities
         type: string

Then you can request those dimensions like any other: add filters, order, or whatever.
Smth like this:

{
  "measures": [
    "base_orders.count"
  ],
  "order": {
    "base_orders.count": "desc"
  },
  "timeDimensions": [
    {
      "dimension": "base_orders.created_at",
      "dateRange": [
        "2019-01-01",
        "2021-01-02"
      ]
    }
  ],
  "dimensions": [
    "base_orders.created_at_half_year"
  ]
}

The resulting query will automatically include the necessary code as if requesting the time dimension with specified granularity.

Depends on:

• feat(schema-compiler): custom granularity support #8537

Check List

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

[vercel]

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)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-d3	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-dashboard	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-data-table	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-highcharts	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-material-ui	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-react-pivot-table	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm
examples-vue-query-builder	⬜️ Ignored (Inspect)	Visit Preview		Sep 15, 2024 9:53pm