title: Update with Select on QueryDSL is possible? How?
body: <p>I need to run an update statement similar to the one below on MySQL. It updates values in a table based on conditions of rows in the same table. Is there a way to achieve that in QueryDSL JPA (or even that native one)?</p>
  <pre><code>UPDATE items,
         (SELECT id, retail / wholesale AS markup, quantity FROM items)
         AS discounted
      SET items.retail = items.retail * 0.9
      WHERE discounted.markup &gt;= 1.3
      AND discounted.quantity &lt; 100
      AND items.id = discounted.id;
  </code></pre>