LeftJoin results in lost camelcase for joined table?

[juanvilladev]

Hello, I am wondering if this is expected behavior. When I do a left join, my tables are losing their camelcase. Here's what it looks like below:
Query

   const getProductByIdResult = await db
      .select()
      .from(product)
      .leftJoin(productSnapshot, eq(product.id, productSnapshot.productId))
      .where(sql`product_id = ${input.productId}`)
      .orderBy(desc(productSnapshot.version))
      .limit(1);

// Getting the following type back from the query:
const getProductByIdResult: {
  product: {
    id: string;
  };
  product_snapshot: {
    // This should be productSnapshot??
    alloy: string;
    shape: string;
    material: string;
    productId: string;
    description: string;
    effectiveDate: string | null;
    version: number;
    thickness: number;
    dimension: string;
    weightByFoot: number;
  } | null;
}[];

Here are my table definitions:

export const product = pgTable("product", {
	id: text("id").primaryKey().notNull(),
});

export const productSnapshot = pgTable("product_snapshot", {
	productId: text("product_id").notNull().references(() => product.id),
	// You can use { mode: "bigint" } if numbers are exceeding js number limitations
	version: bigint("version", { mode: "number" }).notNull(),
	material: text("material").notNull(),
	shape: text("shape").notNull(),
	alloy: text("alloy").notNull(),
	// You can use { mode: "bigint" } if numbers are exceeding js number limitations
	thickness: bigint("thickness", { mode: "number" }).notNull(),
	dimension: text("dimension").notNull(),
	// You can use { mode: "bigint" } if numbers are exceeding js number limitations
	weightByFoot: bigint("weight_by_foot", { mode: "number" }).notNull(),
	description: text("description").notNull(),
	effectiveDate: timestamp("effective_date", { withTimezone: true, mode: 'string' }).defaultNow(),
},
(table) => {
	return {
		idxProductSnapshotEffectiveDate: index("idx_product_snapshot_effective_date").on(table.effectiveDate),
		productSnapshotPkey: primaryKey(table.productId, table.version)
	}
});

[robreiss]

To solve this issue I used an alias.

export const productSnapshotTable = pgTable("product_snapshot", ...  
export const productSnapshot = alias(productSnapshotTable, "productSnapshot");

That should get you the correct naming in your return json. I use this method to remove my table name prefixes i.e. mydb_product, mydb_product_snapshot, etc.

There is a secondary issue if you use this method. Drizzle insert, update, and delete do not currently support "alias". So for insert, update, and delete you would have to use productSnapshotTable not the alias name.
I actually forked the repo and added alias support for these commands to mysql version so I could always use the alias name in my db code.

[hussion]

same problem, may be a bug ?