A way to specify join type.

[sarangnx]

Issue Description

Is your feature request related to a problem? Please describe.

I'd like to have an option to specify full outer join rather than left outer join in includes

Describe the solution you'd like

Something like this would be nice to have:

Team.findAll({
    include: [{
        model: Players,
        join: 'FULL OUTER'   // <--- a way to specify join type.
    }]
})

Describe alternatives/workarounds you've considered

The only workaround/alternative I have found is to write raw queries.

Issue Checklist

Is this issue dialect-specific?

• No. This issue is relevant to Sequelize as a whole.
• Yes. This issue only applies to the following dialect(s): XXX, YYY, ZZZ

Would you be willing to resolve this issue by submitting a Pull Request?

• Yes, I have the time and I know how to start.
• Yes, I have the time but I don't know how to start, I would need guidance.
• No, I don't have the time, although I believe I could do it if I had the time...
• No, I don't have the time and I wouldn't even know how to start.

[papb]

Thanks for the report, I am also not aware of a better workaround than raw queries for now. If someone else knows a better workaround, please share!

[github-actions]

This issue has been automatically marked as stale because it has been open for 7 days without activity. It will be closed if no further activity occurs. If this is still an issue, just leave a comment or remove the "stale" label. 🙂