Kould

I think this is very relevant to https://github.com/GreptimeTeam/greptimedb/issues/3517

Is `Context::create_module_from_ir()` what you want?

Hope to add Memory Comparable, many KV-based databases can use Memory Comparable to create naturally ordered indexes.

tips: sqlparser-rs already supports modify column: https://github.com/sqlparser-rs/sqlparser-rs/pull/1216

I created PR: https://github.com/GreptimeTeam/sqlparser-rs/pull/11 to support `modify column`

> If the CI failure in [GreptimeTeam/sqlparser-rs#11](https://github.com/GreptimeTeam/sqlparser-rs/pull/11) is easy to fix. We could implement the final syntax in this PR. @KKould Could you please take a look? I checked before...

Step for modify column - Parser supports `Modify Column`: https://github.com/sqlparser-rs/sqlparser-rs/pull/1216 - add `ModifyColumn` on `AlterTableOperation` and `alter_expr::Kind`(greptime-proto) - mapping `alter_expr::Kind::ModifyColumn` to process the logic of modify column: https://github.com/GreptimeTeam/greptimedb/pull/3757 - [src/table/src/metadata.rs](https://github.com/GreptimeTeam/greptimedb/pull/3701/files#diff-1dcf594e08caeaea086f669d4d1a612ebd26a80be7dfd98fec11a7ceeefa2357):...

> Maybe we can specify which value to fill in the `ALTER` statement. I love this idea and will implement it when PR: https://github.com/sqlparser-rs/sqlparser-rs/pull/1216 is merged if you think my...

Got it, then I will implement it in the reverse order of steps

> Hi @KKould, We support flushing and compacting a table via SQL. Would you like to add a fuzz test for column type alteration after #3796? yep, after https://github.com/GreptimeTeam/greptimedb/pull/3796 merged