Add support for Postgres bulk update statement about kysely HOT 3 CLOSED

You can modify the proposed solution to make the casts. We can't add automatic casts since they are database-dependent. We don't know what the column's data type is when you pass in a javascript number for example.

We can't do this automatically. We don't have the information, and never will have, since Kysely is not an ORM.

from kysely.

@koskimas Unfortunately, casting did not work for me (maybe I was doing it wrong).

The problem that Kysely generates PREPARE statement elsewhere without parameter types and Postgres defaults all parameters to 'text'.

Instead of doing it automatically, it is possible to let the user to specify values schema:

  db
    .updateTable("foo")
    .fromValues<{col1: "int", col2: "text"}>([
      {col1: 1, col2: "bar"},
      {col1: 2, col2: "buz"}], "v")
    .whereRef("foo.col1", "=", "v.col1")
    .set(eb => ({
      col1: eb.ref("v.col1"),
      col2: eb.ref("v.col2")
    })
    .execute();

and use provided schema when generating PREPARE statement.

IMHO, Postgres allows to construct such queries and it would be nice if Kysely would provide a standard way to do it as well without converting it to ORM.

from kysely.

Typescript types don't exist in runtime, so no, that's not possible.

from kysely.