feat: support sort by

[chenkovsky]

many DBs support applying sort only within partition, not for entire data set. e.g. https://github.com/apache/spark/blob/1b41079f3f1e6cae12216c90d7820455222ee357/sql/catalyst/src/main/scala/org/apache/spark/sql/catalyst/plans/logical/basicLogicalOperators.scala#L883

[CLAassistant]

All committers have signed the CLA.