Tests from Rails fail with `TinyTds::Error: Ambiguous column name 'id'`

[lcreid]

A number of the Rails tests fail with TinyTds::Error: Ambiguous column name 'id' (or something similar). It appears that the tests were added to Rails 5.2 by: rails/rails#35360, and rails/rails#35441 to test a fix to an issue in the Rails code (rails/rails#35359).

I believe this issue is related to #713.

I'm happy to take a stab at a PR. I will report back if I get blocked on the PR.

[lcreid]

I've opened rails/rails#38337, and submitted rails/rails#38338 to Rails as a proposed fix for this issue.

[lcreid]

The PR to Rails was merged to master and backported. I haven't had a chance to test the MS SQL Server adapter against Rails since the merge. If anyone gets a chance, please post here if it worked or if there were problems.

The Rails PR doesn't fix all the test failures, but it should fix the ambiguous column name errors.

[wpolicarpo]

Closing this as per #745. Thanks @lcreid and @aidanharan.