[Feature]: Support table sorting process

[zhoujinsong]

Description

Currently, the self-optimizing process on the table does not sort the data in the table. If a sorting process is added, it can improve the performance of filtering queries on the sorted fields.

Use case/motivation

Support configuring sorting rules on tables. The data will be sorted according to the rules to improve the query performance of the table.

Describe the solution

• Support configuring sorting rules for table rows.
• Automatically sort the data.
• Support multiple sorting methods, such as regular sorting and z-order sorting.

Subtasks

No response

Related issues

No response

Are you willing to submit a PR?

• Yes I am willing to submit a PR!

Code of Conduct

• I agree to follow this project's Code of Conduct

[link3280]

@zhoujinsong I'm glad to help with this one. Please assign it to me if no one is working on it.