Using date object for sqlite in INSERT INTO SELECT

export const games = sqliteTable("games", {
  id: text("id", { length: 36 })
    .primaryKey()
    .$defaultFn(() => randomUUID()),
  playerId: text("doctor_id")
    .notNull()
    .references(() => users.id),
  name: text("name").notNull(),
  createdAt: integer("created_at", { mode: "timestamp" }).notNull(),
  updatedAt: integer("updated_at", { mode: "timestamp" }).notNull(),
  deletedAt: integer("deleted_at", { mode: "timestamp" }),
});

const result = await db.insert(games).select(
  db
    .select({
      playerId: users.id,
      name: users.firstName, // Need current name from users table
      createdAt: sql<Date>`${gameStartDate}`.as("created_at"),
      updatedAt: sql<Date>`${gameStartDate}`.as("updated_at"),
    })
    .from(users)
    .where(eq(users.id, ctx.user.id))
);