title: Kohana 2 ORM: ->with() for has_many relations
body: <p>We have a table for articles, and a table for locale data for articles.</p>
  
  <pre><code>class Article_Model extends ORM {
      protected $has_many = array('article_translations');
  </code></pre>
  
  <p>[...]</p>
  
  <pre><code>class Article_Translation_Model extends ORM {
  </code></pre>
  
  <p>[...]</p>
  
  <p>'articles_translations' table contain 'article_id', 'locale_id', 'heading', 'body', etc. columns.</p>
  
  <p>Is it possible to do</p>
  
  <pre><code>SELECT article.id, article_translations.heading, article_translations.body
  FROM articles
  JOIN articles_translations ON (articles_translations.article_id = article.id)
  WHERE articles_translations.locale_id = 'en_US.UTF-8'
  </code></pre>
  
  <p>using Kohana 2 ORM?</p>
  
  <p>The ->with() construction works only for has_one relations. The articles_translations.article_id and articles_translations.locale_id is UNIQUE, of course.</p>