How to build the UPDATE..FROM query using squirrel
Author: lordvidexCreated Nov 28, 2024Updated Nov 28, 2024
Following this stackoverflow post. It is possible in postgresql to execute the below query:
update test as t set
column_a = c.column_a
from (values
('123', 1),
('345', 2)
) as c(column_b, column_a)
where c.column_b = t.column_b;Is there a possible way to construct a squirrel statement for this type of query?
Source: Masterminds/squirrel