Maybe you can support schemas in more dialects by using a similar approach to a little tool I made: sqlscope.netlify.app

Basically integrate sqlglot to translate the schema between dialects and then use a base dialect for generating the schema.

The two tools seem complementary and you seem to be a better designer, so it would be nice to see it all together