getting type errors errors on my joins

[flippedoffbit]

---

Description of the problem:

I am encountering persistent TypeScript type errors when using join syntax in Drizzle, even when following the documented patterns and ensuring that there is only one table instance in my codebase. Specifically, when I perform:

const result = await db
  .select({ ... })
  .from(flightSchedules)
  .leftJoin(users, eq(flightSchedules.userId, users.id))
  .where(
    and(
      gte(flightSchedules.departureTime, new Date()),
      lte(flightSchedules.departureTime, endDate),
      eq(users.organizationId, organizationId)
    )
  )
  .orderBy(flightSchedules.departureTime);

import { pgTable, serial, varchar, integer, timestamp, doublePrecision } from 'drizzle-orm/pg-core';
import { users } from './user';
import { aircraft } from './aircraft';

export const flightSchedules = pgTable('flight_schedules', {
    id: serial('id').primaryKey(),
    flightNumber: varchar('flight_number', { length: 255 }).notNull(),
    departureAirport: varchar('departure_airport', { length: 255 }).notNull(),
    arrivalAirport: varchar('arrival_airport', { length: 255 }).notNull(),
    departureTime: timestamp('departure_time').notNull(),
    arrivalTime: timestamp('arrival_time').notNull(),
    duration: integer('duration').notNull(),
    aircraftId: integer('aircraft_id').notNull().references(() => aircraft.id),
    userId: integer('user_id').notNull().references(() => users.id),
    instructorId: integer('instructor_id').references(() => users.id),
    flightType: varchar('flight_type', { length: 50 }).notNull(), // e.g., 'solo', 'dual', 'cross-country'
    status: varchar('status', { length: 50 }).notNull().default('scheduled'), // e.g., 'scheduled', 'completed', 'cancelled'
    remarks: varchar('remarks', { length: 500 }),
    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at').defaultNow().notNull(),
    etimatedOffBlock: timestamp('estimated_off_block'),
    actualOffBlock: timestamp('actual_off_block'),
});

import { pgTable, serial, integer, varchar, timestamp, boolean, jsonb, text } from 'drizzle-orm/pg-core';
import { organizations } from './organization';

// Define role as a string enum
export enum UserRole {
    ADMIN = 'admin',
    SCHOOL_ADMIN = 'school_admin',
    INSTRUCTOR = 'instructor',
    STUDENT = 'student',
}

export const users = pgTable('users', {
    id: serial('id').primaryKey(),
    organizationId: integer('organization_id').notNull().references(() => organizations.id),
    role: varchar('role', { length: 50 }).notNull().$type<UserRole>().default(UserRole.STUDENT),
    username: varchar('username', { length: 100 }).notNull().unique(),
    email: varchar('email', { length: 255 }).notNull().unique(),
    passwordHash: varchar('password_hash', { length: 255 }).notNull(),
    firstName: varchar('first_name', { length: 100 }).notNull(),
    lastName: varchar('last_name', { length: 100 }).notNull(),
    phone: varchar('phone', { length: 50 }),
    createdAt: timestamp('created_at').defaultNow().notNull(),
    updatedAt: timestamp('updated_at').defaultNow().notNull(),
    isActive: boolean('is_active').default(true).notNull(),
    remartks: varchar('remarks', { length: 500 }),
    lastLogin: timestamp('last_login'),
    certification: varchar('certification', { length: 100 }),
    computerNumber: varchar('computer_number', { length: 100 }),
    medicalAssessment: varchar('medical_assessment', { length: 100 }),
    medicalAssessmentExpiryDate: timestamp('medical_assessment_expiry_date'),
    typeRating: jsonb('type_rating').$type<{ aircraftIds: number[]; }>(),
    profilePictureUrl: varchar('profile_picture_url', { length: 255 }),
    assessmentsGiven: integer('assessments_given').default(0),
    creditsRemaining: integer('credits_remaining').default(0),
    usertIncidentReports: jsonb('user_incident_reports').$type<{
        id: number;
        description: string;
        date: string;
        severity: 'low' | 'medium' | 'high';
        createdAt: string;
    }[]>(),
});

export type User = typeof users.$inferSelect;
export type NewUser = typeof users.$inferInsert;

I receive the following error:

Argument of type 'PgTableWithColumns<...>' is not assignable to parameter of type 'PgTable<TableConfig>'.

• Both flightSchedules and users are imported from a single schema file.
• There are no duplicate table definitions or alternate import paths.
• This problem occurs consistently in all join attempts, not just with these tables.
• My only workaround has been to avoid joins and instead perform step-by-step selects.

Is there a recommended way to resolve or debug this persistent type mismatch? Is there a known issue or best practice for troubleshooting this scenario?