Cluster functions are not effective if I create a table AS table function.

### Company or project name

ClickHouse

### Describe the situation

Fast:
```
SELECT count() FROM url('https://clickhouse-public-datasets-eu-west-1.s3.eu-west-1.amazonaws.com/hits_1t/{0001..1000}.parquet')
```

Slow:
```
CREATE TABLE hits AS s3('s3://clickhouse-public-datasets-eu-west-1/hits_1t/{0001..1000}.parquet');
SELECT count() FROM hits
```

### Which ClickHouse versions are affected?

.

### How to reproduce

.

### Expected performance

_No response_

### Additional context

_No response_