Provide a mechanism for Query.where to match on values in the database without first having to fetch them

[joeconwaystk]

In a simple case, this may be: SELECT * FROM t where t.column = t.otherColumn. There are two scenarios to consider: the RHS is a value from the table(s) being queried, or the RHS is a value provided by the result of some other query (e.g., SELECT * FROM t where t.column = (SELECT u.id FROM u WHERE <some condition>)).

This may require two different APIs. In the former case, staying as close to the current property selector syntax (where((o) => o.property)) is preferred. The latter case requires more research.