[BUG]: Postgres Schema and Table name not properly escaped

[deanvanniekerk]

What version of drizzle-orm are you using?

0.30.10

What version of drizzle-kit are you using?

0.21.4

Describe the Bug

Given a postgres schema and table name:

export const transactions = pgSchema("transactions");

export const TokenSwapInTransactions = transactions.table(
  "TokenSwap",
  {
    swapId: text("swapId").primaryKey().notNull(),
    transactionHash: text("transactionHash").notNull()
  }
);

when performing this query

const lastTokenSwapQuery = db.query.TokenSwapInTransactions.findFirst({
    orderBy: (tokenSwap, { desc }) => [desc(tokenSwap.logIndex)],
});

causes the following run time error

PostgresError: relation "transactions.TokenSwap" does not exist

the issue is that the schema and table name are not being correctly escaped

Expected behavior

Schema and Table names should be escaped in the format "{schema}"."{table}".

so in the example above "transactions.TokenSwap" should be "transactions"."TokenSwap"

Environment & setup

nodejs v20

[deanvanniekerk]

im so DUMB, I was pointing to the wrong db. This is not a bug.