[Feature Request]: Sort based query processing

### Is there an existing issue for the same feature request?

- [X] I have checked the existing issues.

### Is your feature request related to a problem?

```Markdown
Our query execution at this moment is largely hash based.
In many situations, a sort based algorithm is more
efficient (faster) and more stable (requires less and more
predictable resource).
```

### Describe the feature you'd like

Sort based query processing.

### Describe implementation you've considered

_No response_

### Documentation, Adoption, Use Case, Migration Strategy

_No response_

### Additional information

_No response_