Add support for Nessie catalog

[grifenx]

Issue / Problem Statement:
As of now SQLmesh Trino doesn't support Nessie catalog due to absence of views in functionality (as stated in https://sqlmesh.readthedocs.io/en/stable/integrations/engines/trino/#aws-glue).
Currently THERE IS support of Iceberg views in Nessie, which allows for Trino - Nessie setups, which is being widely adopted at the moment.

Proposed solution:
Add support for Nessie catalog for Trino setups.

[erindru]

There are two modes to configure Nessie within Trino:

• As an Iceberg REST catalog, eg iceberg.catalog.type=rest
• As a Nessie "native" catalog, eg iceberg.catalog.type=nessie

According to the Trino docs, iceberg.catalog.type=nessie still does not support views?

The Nessie catalog does not support view management or materialized view management

Which mode were you trying to run it under?

It works today if its running in rest mode. From our docs:

The Trino Iceberg Connector must be configured with an iceberg.catalog.type that supports views. At the time of this writing, this is hive_metastore, glue, and rest

[erindru]

Guidance on how to use Trino/Nessie with SQLMesh is now live