ClickHouse enforces timestamptz

[mytototo]

Describe the bug
Working with Date types from ClickHouse doesn't work, and timestamptz is always enforced even though it's not supported.

To Reproduce
Create a ClickHouse table with a Date column:

CREATE TABLE series (
  date Date,
);

Create Cube.js model, as pasted below.

Then, query the date column, for example:

{
  "dimensions": [
    "series.date"
  ]
}

You will see an error:

Query failed: Error: Unknown data type family: timestamptz. Maybe you meant: ['TIMESTAMP']:

Indeed, the generated SQL is as follow:

SELECT
  timezone('UTC', "series".date :: timestamptz) "series__date"
FROM
  series AS "series"
GROUP BY
  1
ORDER BY
  1 ASC
LIMIT
  10000

Expected behavior
A clear and concise description of what you expected to happen.

Minimally reproducible Cube Schema

cube("Series", {
  data_source: "clickhouse",

  sql: `
    SELECT * FROM series
  `,

  dimensions: {
    date: {
      type: "time",
      sql: "date",
    },
  },
});

Version:
1.6.1

[igorlukanin]

Hi @mytototo 👋

I suspect you have CUBEJS_DB_TYPE misconfigured. The SQL that is generated for this query does not look like it's generated by the ClickHouse driver. Please check your env vars and driver_factory configuration, if any.

This is what is generated for me for the query you show above: