DDC-3623: [GH-1337] Paginator OrderBy fix take 2

[doctrinebot]

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of zeroedin-bill:

Url: #1337

Message:

This PR fixes issues created in #1220, reported in #1267. The original PR was reverted in #1283.

The issue was that in queries ordered by joined association columns, the joined column aliases did not exist in the outer query created in LimitSubqueryOutputWalker.

This PR adds functionality to LimitSubqueryOutputWalker which finds any such columns referenced in the OrderBy clause, and adds them to the SelectStatement prior to SQL generation.

[doctrinebot]

• is required for DDC-3606: [GH-1325] fixed PostgreSQL and Oracle pagination issues
• is required for DDC-3629: [GH-1342] Paginator functional tests

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1337] was labeled:
#1337

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1337] was labeled:
#1337

[doctrinebot]

Issue was closed with resolution "Fixed"

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1337] was assigned:
#1337