title: Using Sequel, can I create UPDATE statements with a FROM clause
body: <p>Using <a href="http://sequel.rubyforge.org" rel="noreferrer">Sequel</a> I'd like to create an UPDATE statement like the following (from <a href="http://www.postgresql.org/docs/9.1/static/sql-update.html" rel="noreferrer">Postgres docs</a>)</p>
  
  <pre><code>UPDATE employees SET sales_count = sales_count + 1 FROM accounts
    WHERE accounts.name = 'Acme Corporation'
    AND employees.id = accounts.sales_person;
  </code></pre>
  
  <p>However, looking at the <a href="http://sequel.rubyforge.org/rdoc/classes/Sequel/Dataset.html#method-i-update" rel="noreferrer">Sequel documentation</a> it's not clear where there's any way to create the FROM clause.</p>
  
  <p>Is there a way to do this?</p>
  
  <p>Thanks!</p>