onConflictDoUpdate

export const groupDay = pgTable(
  "groupDay",
  {
    id: uuid().defaultRandom().primaryKey().unique().notNull(),
    name: varchar({ length: 256 }).notNull(),
    isSelected: boolean().default(false),
    isArchavized: boolean().default(false).notNull(),
    userId: uuid()
      .references(() => user.id, { onDelete: "cascade" })
      .notNull(),
  },
  (thisTable) => {
    return [uniqueIndex("groupDayNameUserIdUniqueIndex").on(lower(thisTable.name), thisTable.userId)];
  }
);

const drizzleResponse = await drizzleClient
  .insert(groupDay)
  .values({
    name: name,
    userId: userSession.id,
  })
  .returning({
    id: groupDay.id,
  })
  .onConflictDoUpdate({
    target: [groupDay.name, groupDay.userId],
    targetWhere: and(eq(sql`lower(${groupDay.name})`, name.toLowerCase()), eq(groupDay.userId, userSession.id)),
    set: {
      name: name,
      isArchavized: false,
    },
  });