I wrote the 2 unit tests below to illustrate an issue I am facing with subqueries used within the where clause of an outer query. My expectation is that I should be able to use a subquery anywhere I ...

When joining a subquery in a delete operation, the bindings for the "where" come before the bindings for the "join", causing the resulting query not to be what is expected. This could be dangerous ...