Add `ORDER BY` support to new SQL build

[shangyian]

Summary

Add ORDER BY support to the new SQL build. This change also adds the orderby option for the /sql/measures/v2 endpoint, allowing users to specify order by clauses like default.hard_hat.state DESC.

Test Plan

• [x] PR has an associated issue: #1175
• [x] make check passes
• [x] make test shows 100% unit test coverage

Deployment Plan

[netlify[bot]]

✅ Deploy Preview for thriving-cassata-78ae72 canceled.

Name	Link
🔨 Latest commit	9ea17e8145d7cb0cf92e08800f91db1a2692a2e9
🔍 Latest deploy log	https://app.netlify.com/sites/thriving-cassata-78ae72/deploys/66f227f0a0080f000857cfbd

[netlify[bot]]

✅ Deploy Preview for thriving-cassata-78ae72 canceled.

Name	Link
🔨 Latest commit	c4339889b3cfbcc9d3db58bfb3bc139e6cb11ac9
🔍 Latest deploy log	https://app.netlify.com/sites/thriving-cassata-78ae72/deploys/66f2cda70d9be0000906728d