Update with CTE
I am running complex update in SQL, which requires additional context
previously i built it with
UPDATE .. SET .. FROM .. WHERE ..
now i tried to change to WITH .. UPDATE .. SET .. WHERE .. by following the example provided in drizzle docs (https://orm.drizzle.team/docs/update#with-update-clause)
it shows the error of missing FROM-clause entry for table [CTE name here]
may I know if it requires FROM keyword like original query, or without it will works too?Drizzle ORM - Update
Drizzle ORM is a lightweight and performant TypeScript ORM with developer experience in mind.
0 Replies