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 SQLite yet. This issue is to track demand and use cases for implementing this new relation load strategy for SQLite.

⚠️ 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.)