Fix Ignored `where` Clauses in `update` Queries

[devinlyons]

This fixes a major bug that causes update statements to ignore where clauses in update queries that have multiple where clauses.

let query = 
    update {
        for c in sales.customer do
        set c.personid (Some 123)
        where (c.personid = Some 456) // <<-- this clause overwritten by the following `where`.
        where (c.customerid = 789) // <<-- this is the only clause that appears in the final query.
    }

[devinlyons]

@JordanMarr, I had some trouble with the unit tests. It might be worth running them yourself before merging this.

[JordanMarr]

Excellent work on identifying and fixing this issue. I hope this didn't lead to any production data problems for you. I verified that this doesn't affect the select and delete builders (as you probably did as well). I will make fixes to test as needed after the merge.

Thank you!

[JordanMarr]

New version published: https://www.nuget.org/packages/SqlHydra.Query/2.1.1

[devinlyons]

Thanks for the quick response on this.

[devinlyons]

@JordanMarr, the update package seems to depend on FSharp.Core 8.0.100-beta.23418.2. This is a prerelease package that I really don't want to use. Would you mind publishing a version that depends on FSharp.Core 7?

[JordanMarr]

Fixed here: https://www.nuget.org/packages/SqlHydra.Query/2.1.2

[devinlyons]

Confirmed. Thank you!