Enable sort query fuzzing with limited memory #15517

Is your feature request related to a problem or challenge?

A new sort query fuzzer for out-of-core sorting has been added in #15501.
However, the memory limit is not enabled because there are known issues that cause external sort queries to fail, resulting in the fuzzer consistently failing. Once these issues are resolved, we can enable the memory limit configuration in the fuzzer.

After this ticket is resolved: #14748
The following update can be made to the sort query fuzzer to increase coverage for memory-limited sorts.

• Support generating queries with arbitrary number of ORDER BY clauses (Currently it's limited to be smaller than number of projected columns)
• Enable special type columns like utf8_low to be used in ORDER BY clauses
• Enable memory limiting functionality in the fuzzer runner
• Increase the fuzzing throughput: now it spent a lot of time verifying the results (by formatting all the sorted results), we can make it more efficient by splitting the test into smaller tests to run in parallel.

Describe the solution you'd like

No response

Describe alternatives you've considered

No response

Additional context

No response