How to write where clause for relation field inside join field

[anhdd-kuro]

For example, I have Post and User collections. I am concerned about user_rels getting unnecessarily big very soon, so I do not create a direct relation field between post and user. Instead of that, I add a Reads collection that collects information about which users have seen which posts.

Post = {
    {
      name: 'reads',
      type: 'join',
      collection: 'reads',
      on: 'collection',
    },
}

User = { 
    {
      name: 'reads',
      type: 'join',
      collection: 'reads',
      on: 'user',
    },
}

const Reads: CollectionConfig = {
  slug: 'reads',
  defaultPopulate: {
    user: true,
    collection: true,
  },
  fields: [
    {
      name: 'user',
      type: 'relationship',
      relationTo: 'users',
      required: true,
      index: true,
    },
    {
      name: 'collection',
      type: 'relationship',
      relationTo: ["posts", "notifications"],
      required: true,
      index: true,
    },
  ],
} satisfies CollectionConfig

Now I want to get only posts that the user

1. has seen
2. hasn't seen yet
   How to achieve that?
   I tried

// User has seen
const postsQuery = {
	where: { 'reads.user': { equals: currentUserId } }
}
const postsQuery = {
	where: { 'reads.user': { in: [currentUserId] } }
}

// user hasn't seen yet  
const postsQuery = {
	where: { 'reads.user': { not_in: [currentUserId] } }
}
const postsQuery = {
	where: { 'reads.user': { exists: false } }
}

But nothing work, I keep getting Failed query error from dizzle
For example for where: { 'reads.user': { in: [currentUserId] } }

errors: [
    {
      message: 'Failed query: select distinct "posts"."id", "posts"."created_at", "posts"."created_at" from "posts" left join "reads" "d8ae7750_66cb_438e_8dad_33085ecabaef" on  = "posts"."id" where ("posts"."_status" = $1 and "d8ae7750_66cb_438e_8dad_33085ecabaef"."user_id" in ($2, $3)) order by "posts"."created_at" desc limit $4\n' +
        'params: published,744,744,10'
    }
  ]