SubQuery parameter is not documented or is not easy to find

[mattpen]

Issue Description

What was unclear/insufficient/not covered in the documentation

I was having an issue with sequelize rewriting my complicated query with subqueries and it was failing. Specifically, sequelize moved my limit and offset parameters to a subquery, but the left join clause remained outside which caused it to fail. I found a stack overflow solution that said to put subQuery: false in the findOptions, and this fixed my problem. However, I could not find this documented at all on the sequelize website, so I'm concerned I'm using a part of the API that will change without warning.

Subquery search (unhelpful): https://sequelize.org/search/?q=subquery

If possible: Provide some suggestion on how we can enhance the docs

I think this option and how to use it should be mentioned in the Limits and Pagination section:
https://sequelize.org/docs/v6/core-concepts/model-querying-basics/#limits-and-pagination

Additional context

[ephys]

This was added in the v7 rewrite https://sequelize.org/docs/v7/querying/select-in-depth/#referencing-associated-models-in-a-parent-where-clause