[BUG]: Query builder does not work with mutiple schemas

[Highlighted-dev]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.36.3

What version of drizzle-kit are you using?

0.36.3

Other packages

No response

Describe the Bug

For my drizzle setup, I am using 3 files (example simplified) and postgresql db:

index.ts

import dotenv from "dotenv";
import { drizzle } from "drizzle-orm/postgres-js";
import postgres from "postgres";

import * as schema2 from "./schema2";
import * as schema from "./schema";
dotenv.config();

const globalForDb = globalThis as unknown as {
  conn: postgres.Sql | undefined;
};
const conn = globalForDb.conn ?? postgres(process.env.DATABASE_URL!);
if (process.env.NODE_ENV !== "production") globalForDb.conn = conn;

export const db = drizzle(conn, { schema: schema });
export const db2 = drizzle(conn, { schema: schema2 });

schema.ts

export const createTable = pgTableCreator((name) => `schema1_${name}`);

export const users = createTable("user", {
  id: varchar("id", { length: 255 })
    .notNull()
    .primaryKey()
    .$defaultFn(() => crypto.randomUUID()),
  name: varchar("name", { length: 255 }),
  email: varchar("email", { length: 255 }).notNull(),
  emailVerified: timestamp("email_verified", {
    mode: "date",
    withTimezone: true,
  }).default(sql`CURRENT_TIMESTAMP`),
  image: varchar("image", { length: 255 }),
  role: varchar("role", { length: 255 }).notNull().default("user"),
});

schema2.ts

export const createTable = pgTableCreator((name) => `schema2_${name}`);

export const comments = createTable(
  "comments",
  {
    id: serial("id").primaryKey(),
    content: text("content").notNull(),
    createdAt: timestamp("created_at", { withTimezone: true })
      .default(sql`CURRENT_TIMESTAMP`)
      .notNull(),
    updatedAt: timestamp("updated_at", { withTimezone: true }).$onUpdate(
      () => new Date()
    ),
    votes: integer("votes").default(0).notNull(),
  }
);

export const commentsRelations = relations(comments, ({ one }) => ({
  user: one(users, { fields: [comments.userId], references: [users.id] }),
}));

The comments in the schema2 are imported from schema1.
The problem is that I can see the relation in drizzle studio and I can get the table with select(), but I can't get the comments with user in the query builder.

Example select() (this works):

    const comments1 = await db
      .select()
      .from(comments)
      .innerJoin(users, eq(comments.userId, users.id));

Example query builder (this doesnt work):

    const comments2 = await db.query.comments.findMany({
      with: {
        user: true,
      },
    });

If I try to use query builder, I am getting following error
Error: Cannot read properties of undefined (reading 'columns')