Update with CTE
I am running complex update in SQL, which requires additional context
previously i built it with
now i tried to change to
it shows the error of
may I know if it requires
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 is a lightweight and performant TypeScript ORM with developer experience in mind.
