How to type the values that go into .update.set()?

[anthonyma94]

When using update.set() to update values in a table, the types work great when putting the values directly into set(). If there are any keys that aren't supposed to be there, I get an error. However, this doesn't work when the values are created elsewhere and passed into the function. As long as there is at least 1 valid key, the values do not throw an error until runtime. What can I type the params with so that it throws an error at build time?

const table = pgTable({
  id: uuid("id").primaryKey(),
  name: varchar("name")
});

await db.update(table).set({
  name: "hello",
  invalid: "world" // throws a type error here
});

const params = {
  name: "hello",
  invalid: "world"
}

await db.update(table).set(params); // no errors are thrown

[Angelelz]

This would be the issue to follow #836.
But you can type it yourself like this:

const params: Partial<typeof table.$inferInsert> = {
  name: "hello",
  invalid: "world"
}
// or
const params = {
  name: "hello",
  invalid: "world"
} satisfies Partial<typeof table.$inferInsert>