[DOCS]: Query relations (`with`) dont support filter (`where`), as shown in docs

[MickL]

Enhancement hasn't been filed before.

• I have verified this enhancement I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

In the docs it is shown twice that a filter (where) can be added to a relation (with) which doesnt seem to be the case. From the docs:

await db.query.posts.findMany({
   where: (posts, { eq }) => (eq(posts.id, 1)),
      with: {
         comments: {
            where: (comments, { lt }) => lt(comments.createdAt, new Date()),
         },
      },
});

But this does not seem to be possible (I wish it would tho):

Found here:

• https://orm.drizzle.team/docs/rqb#select-filters
• https://orm.drizzle.team/docs/rqb#multiple-placeholders

[MickL]

This seems to be rather a bug than wrong documentation, see #3911