Fix handling of empty rows in (left) joined queries

[joelmukuthu]

Currently, when a join does not yield any rows, the joined query is added with value null. To remain consistent with the rest of the Query methods, which return an empty array when no rows are returned, this should be fixed such that:

• if all rows are empty, set the value to []
• if first is configured, set the value to null

This is a breaking change for all code that checks existence of the joined data:

const foo = await Foo.query.join(Bar, { as: 'bar' }).fetch();
if (foo.bar) { // this will fail
} 

NOTE that this only applies to leftJoin. for join and innerJoin the rows should always be non-empty.

• ensure that this only applies to leftJoin
• ensure that for join and innerJoin the rows are always non-empty

[joelmukuthu]

🎉 This issue has been resolved in version 2.0.0 🎉

The release is available on:

• npm package (@latest dist-tag)
• GitHub release

Your semantic-release bot 📦🚀