[Enhancement] can add a feature that a sql run with defaut sort

[Hanchers]

Search before asking

• I had searched in the issues and found no similar issues.

Description

sql like this

SELECT * FROM (
select * from ods_test_table order by id
) x 
LIMIT 20, 10

when run this sql, the result is not sorted .
and my usage is a data preview for a sql editor

version : 2.1.0

---

能否在sql执行的时候增加一个默认排序的功能，导致结果是有序的。 现在在分页的时候必须指定排序字段。
但是作为框架的开发者，对于这种嵌套sql的排序时，是无法识别出用户sql的排序字段的。
能否系统级实现这种默认的排序效果。

Solution

No response

Are you willing to submit PR?

• Yes I am willing to submit a PR!

Code of Conduct

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