Feature Request: Support for StarRocks #5610

I would like to use sqlmesh with StarRocks

Although StarRocks uses the MySQL protocol, the existing mysql adapter in sqlmesh does not work for building models. StarRocks requires specific DDL syntax for creating tables (specifically DISTRIBUTED BY and PARTITION BY clauses) that the generic MySQL adapter does not generate.

Without this, I cannot properly create or materialize tables in StarRocks using SQLMesh.

Since sqlglot already supports the starrocks dialect, I am hoping this can be integrated into sqlmesh