[Feature]: more support for non-date type partition key in partition plan

[yhilmare]

Is your feature request related to a problem?

no

Describe the solution you'd like

Users sometimes use non-time type columns as partition keys, and then they usually use them in the same way as time type partition keys. In this case, we need a more friendly way to help users configure the partition plan.

create table range_parti_tbl(
    id int(11),
    parti_key int(11)
) partition by range column(parti_key) (
    partition p0 values less than (20240201),
    partition p1 values less than (20240301),
)

Additional context

No response