title: HQL recursion, how do I do this?
body: <p>I have a tree structure where each <code>Node</code> has a parent and a <code>Set&lt;Node&gt; children</code>. Each Node has a <code>String title</code>, and I want to make a query where I select <code>Set&lt;String&gt; titles</code>, being the title of this node and of all parent nodes. How do I write this query?</p>
  
  <p>The query for a single title is this, but like I said, I'd like it expanded for the entire branch of parents.</p>
  
  <pre><code>SELECT node.title FROM Node node WHERE node.id = :id
  </code></pre>
  
  <p>Cheers</p>
  
  <p>Nik</p>