Issues with left join/ joins in general

[darahask]

Issue with leftJoin in drizzle-orm: TypeScript type incompatibility

I'm encountering a TypeScript error when trying to use leftJoin with drizzle-orm (PostgreSQL). The error message is as follows:

Argument of type 'PgTableWithColumns<{ name: "reward_balance"; ... }>' is not assignable to parameter of type 'SQL<unknown> | Subquery<string, Record<string, unknown>> | PgViewBase<string, boolean, ColumnsSelection> | PgTable<TableConfig>'.
  Type 'PgTableWithColumns<...>' is not assignable to type 'PgTable<TableConfig>'.
    The types of '_.config.columns' are incompatible between these types.
      Type '{ id: PgColumn<...>; ... }' is not assignable to type 'Record<string, PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>>'.
        Property 'id' is incompatible with index signature.
          Type 'PgColumn<...>' is not assignable to type 'PgColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>'.
            The types of 'table._.config.columns' are incompatible between these types.
              Type 'Record<string, ...>' is not assignable to type 'Record<string, ...>'.
                'string' index signatures are incompatible.
                  Type 'PgColumn<...>' is not assignable to type 'PgColumn<...>'.
                    Property 'config' is protected but type 'Column<T, TRuntimeConfig, TTypeConfig>' is not a class derived from 'Column<T, TRuntimeConfig, TTypeConfig>'.ts(2345)

Schema structure

All schema definitions are inside src/db/schema/, split across multiple files and exported via an index.ts. I use pgTable from drizzle-orm/pg-core for all tables.

Example:

export const wallet = pgTable("wallet", {
  id: uuid("id").primaryKey().default(sql`gen_random_uuid()`),
  businessId: uuid("business_id").notNull().references(() => business.id)
});

export const rewardBalance = pgTable("reward_balance", {
  id: uuid("id").primaryKey().default(sql`gen_random_uuid()`),
  walletId: uuid("wallet_id").notNull().references(() => wallet.id).unique(),
  totalEarnedPoints: integer("total_earned_points"),
  totalRedeemedPoints: integer("total_redeemed_points"),
  availablePoints: integer("available_points"),
  lastUpdated: timestamp("last_updated")
});

Query

const walletWithBalance = await tx
  .select({
    wallet: wallet,
    reward_balance: rewardBalance
  })
  .from(wallet)
  .leftJoin(rewardBalance, eq(wallet.id, rewardBalance.walletId))
  .where(eq(wallet.businessId, businessId))
  .limit(1);

The error occurs at the leftJoin function.

---

Has anyone encountered this issue or found a solution?
Is there something wrong with how the schema is imported/exported, or is it a type mismatch between different versions of drizzle-orm or its dependencies?

Any advice would be appreciated!

[darahask]

I am using latest drizzle 0.43.1