Support FROM clause for UPDATE and DELETE statements

[slavaavr]

Hi! Is any option to create such query as:

update table1 set a=table2.b
from table2
where table1.id = table2.fk_id

for postgres db?
What do you think about adding this feature? If you don't mind, I may help with the implementation.

[go-jet]

Hi, @slavaavr . from clause for update and delete statements are not currently supported. The workaround would be to use IN operator or raw statement.
Off course, feel free to contribute.

[go-jet]

This feature is now implemented in the develop branch and will be released later with release version 2.7.0.