Drizzle type question

export const User = mysqlTable('users', {
  id: serial('id').primaryKey(),
  username: text('username').unique(),
  passwordHash: text('password_hash'),
  passwordSalt: text('password_salt'),
  role: mysqlEnum('role', ['user', 'admin']),
  createdAt: timestamp('created_at').notNull().default(new Date()),
  updatedAt: timestamp('updated_at').notNull().default(new Date()),
});
export const Session = mysqlTable('sessions', {
  id: serial('id').primaryKey(),
  token: text('token').unique(),
  csrfToken: text('csrf_token'),
  expiresAt: timestamp('expires_at').notNull(),
  userid: int('user_id').references(() => User.id),
});

export const User = mysqlTable('users', {
  id: serial('id').primaryKey(),
  username: text('username').unique(),
  passwordHash: text('password_hash'),
  passwordSalt: text('password_salt'),
  role: mysqlEnum('role', ['user', 'admin']),
  createdAt: timestamp('created_at').notNull().default(new Date()),
  updatedAt: timestamp('updated_at').notNull().default(new Date()),
});
export const Session = mysqlTable('sessions', {
  id: serial('id').primaryKey(),
  token: text('token').unique(),
  csrfToken: text('csrf_token'),
  expiresAt: timestamp('expires_at').notNull(),
  userid: int('user_id').references(() => User.id),
});

const session = await db
    .select()
    .from(Session)
    .where(eq(Session.token, sessionToken))
    .innerJoin(User, eq(Session.userid, User.id)).limit(1)
    .execute();

const session = await db
    .select()
    .from(Session)
    .where(eq(Session.token, sessionToken))
    .innerJoin(User, eq(Session.userid, User.id)).limit(1)
    .execute();

session: {
    sessions: {
        id: number;
        token: string | null;
        csrfToken: string | null;
        expiresAt: Date;
        userid: number | null;
    };
    users: {
        id: number;
        username: string | null;
        passwordHash: string | null;
        passwordSalt: string | null;
        role: "user" | ... 1 more ... | null;
        createdAt: Date;
        updatedAt: Date;
    };
}[]

session: {
    sessions: {
        id: number;
        token: string | null;
        csrfToken: string | null;
        expiresAt: Date;
        userid: number | null;
    };
    users: {
        id: number;
        username: string | null;
        passwordHash: string | null;
        passwordSalt: string | null;
        role: "user" | ... 1 more ... | null;
        createdAt: Date;
        updatedAt: Date;
    };
}[]