bigdata - Hot do automatically generate sqls and test them according to semantics and grammar of a DDL?

Question

For example, there is a table ddl pattern:

CREATE TABLE [IF NOT EXISTS]
  [<database_name>.]<table_name>　
  [(<column_name> <data_type> [COMMENT '<column_comment>'] 
    [, <column_name> <data_type> ...])]
  [COMMENT '<table_comment>'] 
  [PARTITIONED BY (<part_key> <data_type> [COMMENT '<partition_comment>']    
    [, <part_key> <data_type>...])] 
  [CLUSTERED BY (<col_name> [, <col_name>...])  
    [SORTED BY (<col_name> [ASC|DESC] [, <col_name> [ASC|DESC]...])] 
  INTO <num_buckets> BUCKETS]
  STORED AS TABLE_TYPE WITH ((TABLESIZE <table_size>KB|MB|GB|TB|PB|EB|ZB|BB) | (TABLET NUMBER <tablet_number> CAPACITY NUMBER <capacity_number> REPLICATION <replication_number>))  
  [TBLPROPERTIES ('<property_name>'='<property_value>', ...)]
  [SERDEPROPERTIES ('<property_name>'='<property_value>', ...)];

Are there some open source tools could generate sqls and test them automatically if the DDL pattern given?

question from:https://stackoverflow.com/questions/66057314/hot-do-automatically-generate-sqls-and-test-them-according-to-semantics-and-gram

Answer 1

Waitting for answers