...

The disadvantage of this solution is that it cannot cover the entire scene.

Because this  This solution is only applicable to the way of create catalog using DDL , because we only can get the Catalog options through the with keyword. If we use the Catalog registered in by TableEnvironment#registerCatalog method, we cannot get optionsthe options can not be got. There are a large number of users who use TableEnvironment#registerCatalog to register the Catalog in the production environment.  Consider the above, we reject this plan.

References

1. Support SELECT clause in CREATE TABLE(CTAS)
2. MySQL CTAS syntax
3. Microsoft Azure Synapse CTAS
4. LanguageManual DDL#Create/Drop/ReloadFunction
5. Spark Create Table Syntax

...