In versions 5.7.0 and 5.10.0 we released support for a new relation load strategy for PostgreSQL and MySQL as part of the relationJoins preview feature:

• Documentation: https://www.prisma.io/docs/orm/prisma-client/queries/relation-queries#relation-load-strategies-preview
• Launch blog post: https://www.prisma.io/blog/prisma-orm-now-lets-you-choose-the-best-join-strategy-preview

We have not implemented the same functionality for SQL Server yet. This issue is to track demand and use cases for implementing this new relation load strategy for SQL Server.

⚠️ Please upvote the issue by leaving a 👍 reaction. (Please do not comment with +1 or similar. Only "upvotes" on the issue itself will be taken into account, and comments without actual content will be hidden.)