update foo set bar = ( select {complex_expr} new_bar from {some_tables} where {complex_join} and foo.id = {some_table}.id) where {condition_goes_here} in Postgres (i.e. complex update based on a ...