Allow Run Query with Remote Table Function in Clickhouse-local #5627 (proller)

Why it matters

This feature allows clickhouse-local users to perform queries that fetch data from remote ClickHouse servers, facilitating distributed query execution and testing in a local environment without a full server setup.

How to use it

Within clickhouse-local, use the remote table function as normally done in ClickHouse server queries, for example:

sql<br>SELECT * FROM remote('host:port', 'database', 'table')<br>
This requires network access to the remote ClickHouse server and appropriate permissions.