DDC-3436: [GH-1212] [DDC-3108] Fix regression where join aliases were no longer accessible in Criteria expressions

[doctrinebot]

Jira issue originally created by user @doctrinebot:

This issue is created automatically through a Github pull request on behalf of kieljohn:

Url: #1212

Message:

The solution to issue DDC-2764 was to blanket prefix all the fields with the root alias. The result was then impossible to use fields from multiple FROM tables or a JOIN.

This patch injects all available aliases into the comparison, if a field uses one of the aliases it will pass without modification. If it is an unknown alias it will prefix the first rootAlias listed using the same functionality as the deprecated getRootAlias() function.

Also improves the ORDER BY on Criteria expressions, again introduced by [DDC-2764] using the above functionality, this was out of scope of bug [DDC-3108].

Added unit tests to test new functionality.

[doctrinebot]

• relates to DDC-2764: An orderBy on Criteria leads to DQL semantical error
• relates to DDC-3108: Criteria cannot reference a joined tables' fields when used with an ORM QueryBuilder

[doctrinebot]

Comment created by @doctrinebot:

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

[doctrinebot]

Comment created by @doctrinebot:

A related Github Pull-Request [GH-1212] was closed:
#1212

[doctrinebot]

Issue was closed with resolution "Fixed"