title: Return updated row attributes on UPDATE
body: <p>My query is as follow:</p>
  
  <pre><code>UPDATE t1 SET t1.foreign_key = (SELECT id FROM t2 WHERE t2.col = %s ) 
  WHERE t1.col = %s
  </code></pre>
  
  <p>How do I return some attributes of the updated row in the table in the same query?</p>