table not being camelcased when using joins?

    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);

const getProductByIdResult: {
    product: {
        id: string;
    };
    product_snapshot: {
        alloy: string;
        shape: string;
        material: string;
        productId: string;
        description: string;
        effectiveDate: string | null;
        version: number;
        thickness: number;
        dimension: string;
        weightByFoot: number;
    } | null;
}[]