Orderby in including relations

const sponsorships = await this.drizzleClient.query.sponsorshipDbSchema.findMany({
      orderBy: orderByDate,
      where: (sponsorship, { and, eq: whereEq }) => {
        if (!state) {
          return whereEq(sponsorship.type, SponsorshipTypeEnum.REFERRAL_SPONSORSHIP)
        }
        return and(whereEq(sponsorship.state, state), whereEq(sponsorship.type, SponsorshipTypeEnum.REFERRAL_SPONSORSHIP))
      },
      with: {
        mission: {
          columns: { createdAt: true, job: true },
          orderBy: (missions, { asc: orderByAsc }) => [orderByAsc(missions.createdAt)],
          with: { contact: { columns: { firstname: true, lastname: true } }, customer: { columns: { name: true } } },
        },
        sponsee: {
          columns: { createdAt: true, email: true, firstname: true, lastname: true, linkedIn: true, phoneNumber: true },
        },
        user: {
          columns: { createdAt: true, email: true, firstname: true, lastname: true, phoneNumber: true, userId: true },
          with: { company: { columns: { siret: true } } },
        },
      },
    })

const sponsorships = await this.drizzleClient.query.sponsorshipDbSchema.findMany({
      orderBy: orderByDate,
      where: (sponsorship, { and, eq: whereEq }) => {
        if (!state) {
          return whereEq(sponsorship.type, SponsorshipTypeEnum.REFERRAL_SPONSORSHIP)
        }
        return and(whereEq(sponsorship.state, state), whereEq(sponsorship.type, SponsorshipTypeEnum.REFERRAL_SPONSORSHIP))
      },
      with: {
        mission: {
          columns: { createdAt: true, job: true },
          orderBy: (missions, { asc: orderByAsc }) => [orderByAsc(missions.createdAt)],
          with: { contact: { columns: { firstname: true, lastname: true } }, customer: { columns: { name: true } } },
        },
        sponsee: {
          columns: { createdAt: true, email: true, firstname: true, lastname: true, linkedIn: true, phoneNumber: true },
        },
        user: {
          columns: { createdAt: true, email: true, firstname: true, lastname: true, phoneNumber: true, userId: true },
          with: { company: { columns: { siret: true } } },
        },
      },
    })