The SQL Server platform throws an error when you try to run DQL with JOIN statements.
The breaking change was in the DBAL SQL Server platform – it was changed to add a ' WITH (NOLOCK)' to the appendLockHint function. Change was in this rev. The change in DBAL is not wrong, it just highlighted the bug in the ORM...
The ORM SqlWalker runs the appendLockHint function against a generated FROM / JOIN clause in the walkFromClause func here. This is actually the wrong place to append lock hints. This is generating the FROM clause like:
When it should actually generate something like:
It should append lock hints after the table alias.
I think the only reason this hasn't shown up before is that the other lock hint types haven't been applied in this way before, if at all.