[RQBV2]TypeError: operators[target] is not a function

[siamahnaf]

Hello, I am excited to see the drizzle relational API v2, and finally today I am trying to implement it.

Most wanted feature is filter with relational field(Column)

Here is my table-

import { uuid, text } from "drizzle-orm/pg-core";
import { auth } from "../init";

export const user = auth.table("user", {
    id: uuid("id").primaryKey().defaultRandom(),
    email: text("email")
});

export const profile = auth.table("profile", {
    id: uuid("id").primaryKey().defaultRandom(),
    name: text("name"),
    user: uuid("user").references(() => user.id)
});

And here is my relations-

import { defineRelations } from "drizzle-orm";

//Schemas
import * as schema from "../schemas";

export const relations = defineRelations(schema, (r) => ({
    user: {
        profile: r.one.profile({
            from: r.user.id,
            to: r.profile.user
        })
    },
    profile: {
        user: r.one.user({
            from: r.profile.user,
            to: r.user.id
        })
    }
}));

Then-

import { drizzle } from "drizzle-orm/neon-http";
import { neon } from "@neondatabase/serverless";

//Schemas
import { relations } from "../relations";

const sql = neon(process.env.DATABASE_URL!);

//Creating Drizzle DB
export const db = drizzle({ client: sql, relations });

Finally time to query-

const data = await db.query.profile.findMany();
[{"id":"28c4c9be-b3bc-44c0-87f8-b787cfa85f6e","name":"Siam 1","user":"a1354b5d-d8b7-4924-9353-3a9c0c6654c1"},{"id":"396b86b3-3db2-4512-88b1-d82e809df139","name":"Siam 2","user":"e906edb8-2127-4c68-92c8-af7e2fa5d616"}]

But I am facing the error when trying to filter with relation table column like-

const data = await db.query.profile.findMany({
    where: {
      user: {
        email: "[email protected]"
      }
    }
  });

It given me this error-

Error - TypeError: operators[target] is not a function

Following is my some other try-

const data = await db.query.profile.findMany({
    where: {
      user: {
        email: {
          eq: "[email protected]"
        }
      }
    }
  });
  
   const data = await db.query.profile.findMany({
    where: {
      user: {
        email: {
          eq: "[email protected]"
        }
      }
    },
    with: {
      user: true
    }
  });

None is working, facing same error. Seems it is a bug or I am doing something wrong. I don't know where I need create issues.

Here is full error details-