K
Kyselylukas.slezevicius

Derived tables for Postgres

Hi, I am trying to do a bulk update like this: 
UPDATE your_table
SET someColumn = new_values.new_value
FROM (VALUES
    (1, 'new_value_for_row_1'),
    (2, 'new_value_for_row_2')
    -- Add more rows as needed
) AS new_values (id, new_value)
WHERE your_table.id = new_values.id;
UPDATE your_table
SET someColumn = new_values.new_value
FROM (VALUES
    (1, 'new_value_for_row_1'),
    (2, 'new_value_for_row_2')
    -- Add more rows as needed
) AS new_values (id, new_value)
WHERE your_table.id = new_values.id;
I found that UpdateQueryBuilder supports update joins with from method, but I couldn't find how to create derived tables like in the pure SQL shown above. Thanks!
Want results from more Discord servers?
Add your server
More Posts
Complex Query Builder from dynamic input - Typescript issueHi, it's me - again 🙂 I'm currently trying to migrate our current query builder. It seems that eHow to add table/column comments when creating tables?Hey, we're approaching close to 100 tables in our project. New people will be joining our founding tNeed help improving a custom helperMy dopamine with Kysely is quite high right now, so I am experimenting all sorts of things to createjsonArrayFrom with `as` not being typedI have the following query ```ts await db .selectFrom('user') .selectAll() .select((eb)