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

Although they usually overlap, this currently does not include MariaDB via the mysql datasource provider.

Unfortunately MariaDB does not support correlated subqueries, the method we use for this new relation load strategy for MySQL. (It also does not supports lateral joins, the method we use for PostgreSQL.) We would need to implement a completely different approach for MariaDB.

This issue is to track demand and use cases for implementing this new relation load strategy for MariaDB.

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