[BUG]: DrizzleQueries are failing because of missing schema name (Postgres)

[maxdollinger]

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.39.1

What version of drizzle-kit are you using?

0.30.4

Other packages

No response

Describe the Bug

We use pgSchema for our table definitions like:
export const user = pgSchema('app_one').table('user', { id: integer('id').generatedAlwaysAsIdentity().primaryKey(), name: text('name'), })

When making a query like db.query.user.findMany() the produced sql code looks like this select "id", "name" from "user" which fails because the schema is missing. It should be select "id", "name" from "app_one"."user"

When using the query builder like db.select().from(user) the produced sql is correct select "id", "name" from "app_one"."user"

[maxdollinger]

Here some minimal code example with PGlite.

import { PGlite } from "@electric-sql/pglite";
import { integer, pgSchema, text } from "drizzle-orm/pg-core";
import { drizzle } from "drizzle-orm/pglite";

const user = pgSchema('app_one').table('user', { id: integer('id').generatedAlwaysAsIdentity().primaryKey(), name: text('name') });

const client = new PGlite();

await client.exec('CREATE SCHEMA "app_one";');
await client.exec('CREATE TABLE IF NOT EXISTS "app_one"."user" ("id" integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY (sequence name "app_one"."user_id_seq" INCREMENT BY 1 MINVALUE 1 MAXVALUE 2147483647 START WITH 1 CACHE 1), "name" text);');

const db = drizzle(client, {
    schema: { user }, logger: {
        logQuery(query, params) {
            console.log(`[Drizzle] ${query} -- [${params.join(',')}]`);
        }
    }
});

// works
await db.select().from(user);

// does not work
await db.query.user.findMany();

[maxdollinger]

If i add another if clause in buildFromTable in src/pg-core/dialect.ts (line 308)

if (is(table, Table) && table[Table.Symbol.Schema]) {
    return sql`${sql.identifier(table[Table.Symbol.Schema])}.${sql.identifier(table[Table.Symbol.Name])}`;
}

the issue is no longer present, but looking at the change history i can hardly believe this should be the issue.

[Eiley2]

If someone else is having this issue, you can downgrade drizzle-orm to 0.38.4 and it works just fine