Non-external preaggregations do not function when using ClickHouse Cloud

[maxehmookau]

Describe the bug

When creating a pre-aggregation and not using cubestore, but using ClickHouse Cloud (ClickHouse's IaaS platform) to store the pre-aggregation the creation fails.

As a result, it is impossible to define internal preaggregations using ClickHouse when using ClickHouse Cloud.

To Reproduce

1. Use ClickHouse Cloud to store some data and create a simple Cube schema to model that data.
2. Define a preaggregation but do not use cubestore. Define external: false so that the pre-aggregation is stored in ClickHouse.
3. Notice that the creation fails because CREATE AS SELECT statements are not supported in ClickHouse Cloud. (See Compatibility Guide)

Expected behavior
The pre-aggregation should be created in the ClickHouse Cloud database as expected.

Possible fixes

• This line will need to be changed. The CREATE AS SELECT statement can be replaced with two statements, one to create the table and another to populate it. However, this method only accepts a single query.
• Because it inherits from BaseQuery, it may require a more extensive refactor.

[github-actions]

If you are interested in working on this issue, please leave a comment below and we will be happy to assign the issue to you.
If this is the first time you are contributing a Pull Request to Cube.js, please check our contribution guidelines.
You can also post any questions while contributing in the #contributors channel in the Cube.js Slack.

[igorlukanin]

It is recommended to use Cube Store for storing pre-aggregations: https://cube.dev/docs/product/caching/using-pre-aggregations#pre-aggregations-storage