feat: support sql ORDER BY

Summary

• feat: support sql ORDER BY

• Close sbroad#151 (closed)
• Target branch: master
• Changes should be cherry-picked to 24.2: no
• Docs follow-up: docs#241 (closed)