The join() on option only supports equality comparisons
Hi,
we discovered that if the on
option of a join involves operators, e.g. like in
{
rel: {
on: {
owner_id: 'id',
'assignee_id <>': 'rel.owner_id'
},
....
}
}
The comparison operator is ignored and becomes an equality comparison in the generated SQL.
True, a where clause can be used (at list in this case) to workaround the issue, but sometimes being very selective in the on
clauses makes queries much more efficient.