[FEATURE]: Expose Hive as dialect during install

Is there an existing issue for this?

[X] I have searched the existing issues

Category of feature request

Transpile

Problem statement

Currently Transpile source list doesn't allow selecting hive as the source.

Proposed Solution

SQLGLOT_DIALECTS: dict[str, DialectType] = { "athena": Dialects.ATHENA, "bigquery": Dialects.BIGQUERY, "databricks": databricks.Databricks, "experimental": experimental.DatabricksExperimental, "hive": Dialects.HIVE "mysql": Dialects.MYSQL, "netezza": Dialects.POSTGRES, "oracle": oracle.Oracle, "postgresql": Dialects.POSTGRES, "presto": presto.Presto, "redshift": Dialects.REDSHIFT, "snowflake": snowflake.Snow, "sqlite": Dialects.SQLITE, "teradata": Dialects.TERADATA, "trino": Dialects.TRINO, "tsql": Dialects.TSQL, "vertica": Dialects.POSTGRES, }

Additional Context

No response

databrickslabs / remorph