Getting typescript error when using where clause inside with in query API.

ts: Object literal may only specify known properties, and 'where' does not exist in type

ts: Object literal may only specify known properties, and 'where' does not exist in type

    const results = await db.query.assignments.findMany({
        where: (assignments, { eq: localEq }) =>
            localEq(assignments.assignedTo, candidateId),
        limit,
        offset,
        columns: {
            id: true,
            startsAt: true,
        },
        with: {
            assessment: {
                where: (assessments, { lt }) => lt(assessments.createdAt, new Date()), // <--- the error is here
                columns: {
                    id: true,
                    title: true,
                    timeLimit: true,
                },
            },
            assigner: {
                columns: {
                    name: true,
                },
            },
        },
        extras: {
            totalRecords: db
                .$count(assignments, eq(assignments.assignedTo, candidateId))
                .as("total_records"),
        },
    });

    const results = await db.query.assignments.findMany({
        where: (assignments, { eq: localEq }) =>
            localEq(assignments.assignedTo, candidateId),
        limit,
        offset,
        columns: {
            id: true,
            startsAt: true,
        },
        with: {
            assessment: {
                where: (assessments, { lt }) => lt(assessments.createdAt, new Date()), // <--- the error is here
                columns: {
                    id: true,
                    title: true,
                    timeLimit: true,
                },
            },
            assigner: {
                columns: {
                    name: true,
                },
            },
        },
        extras: {
            totalRecords: db
                .$count(assignments, eq(assignments.assignedTo, candidateId))
                .as("total_records"),
        },
    });