Typescript issue on nested queries with clientExtensions feature

[malekjaroslav]

Bug description

When clientExtensions feature is added to Prisma some nested queries start throwing Typescript errors . For example this nested query below throws an error saying "tenant" is not available on "version" but it should be. The query works just fine without the extension and weirdly enough it works fine even when take and orderBy are omitted from the query.

How to reproduce

  // When "take" and "orderBy" is included, typescript shows an error
  const contract = await prisma.rentContract.findUniqueOrThrow({
    where: {
      id: "",
    },
    include: {
      tenant: true,
      versions: {
        take: 1,
        orderBy: {
          createdAt: "desc",
        },
        include: {
          tenant: true,
        },
      },
    },
  });
  // Error on tenant
  contract.versions[0]?.tenant.name;

  // When "take" and "orderBy" is excluded, typescript shows correct suggestions
  const contract2 = await prisma.rentContract.findUniqueOrThrow({
    where: {
      id: "",
    },
    include: {
      tenant: true,
      versions: {
        /* take: 1,
        orderBy: {
          createdAt: "desc",
        },*/
        include: {
          tenant: true,
        },
      },
    },
  });
   // No error
  contract2.versions[0]?.tenant.name;

Expected behavior

It should not throw an error

Prisma information

generator client {
  provider        = "prisma-client-js"
  previewFeatures = ["clientExtensions"]
}

datasource db {
  provider = "cockroachdb"
  url      = env("DATABASE_URL")
}


model Tenant {
  id          String         @id @default(cuid())
  name        String
  contracts   RentContract[]

  createdAt DateTime  @default(now())
  deletedAt DateTime?
}



model RentContract {
  id               String              @id @default(cuid())
  tenant           Tenant              @relation(fields: [tenantId], references: [id])
  tenantId         String
  versionOf        RentContract?       @relation("Versions", fields: [versionOfId], references: [id])
  versionOfId      String?
  versions         RentContract[]      @relation("Versions")

  updatedAt DateTime  @updatedAt
  createdAt DateTime  @default(now())
  deletedAt DateTime?
}

Environment & setup

• OS: macOS
• Node.js version: v16.18.0

Prisma Version

4.9.0

[millsp]

Thanks for the report. I can immediately confirm this as it was also reported here #17349.

[jove4015]

@millsp - This bug is marked resolved, however, client extensions still are not usable (see #17767). Is there any progress on making this feature functionally available?

[millsp]

Hey @jove4015, the fix will be release tomorrow. If you want, you can install @prisma/client@dev to try it out.