sqlmesh2clickhouse exporter should support indices and order_by

[ryscheng]

What is it?

Right now we use Clickhouse to power the API. A common query is, give me all contracts from this root deployer.
Without data-skipping indices, Clickhouse scans everything, which inevitably times out.

Previously in dbt land, we specified these things in model metadata, so that the export can read it per model and construct the table appropriately.
We don't have a similar facility in sqlmesh yet.

Also, this might be moot if we move to consumer Trino
#3181

[linear]

OSO-473 sqlmesh2clickhouse exporter should support indices and order_by