title: Django filter based in joined table
body: <p>I have two tables:</p>
  
  <pre><code>class Client(models.Model):
      name = models.TextField()
      lastname = models.TextField()
  
      class Meta:
          managed = False
          db_table = 'client'
  
  class Clientreport(models.Model):
          id_client_home = models.ForeignKey('Client', models.DO_NOTHING, db_column='id_client_home', related_name='home_id_client_home')
          id_client_reported = models.ForeignKey('Client', models.DO_NOTHING, db_column='id_client_reported', related_name='client_id_client_home')
  
          class Meta:
              managed = False
              db_table = 'clientreport'
  </code></pre>
  
  <p>And I'm trying to build a query similar to this:</p>
  
  <pre><code>SELECT cr.*, cl.id, cl.name, cl.lastname FROM Clientreport cr INNER JOIN Client cl ON cr.id_client_reported = cl.id 
  WHERE (LOWER(cl.name) LIKE LOWER('%jo%') OR LOWER(cl.lastname) LIKE LOWER('%jo%') ) 
  </code></pre>
  
  <p>I tried using:
  <a href="https://docs.djangoproject.com/en/1.11/topics/db/sql/" rel="noreferrer">SQL queries</a></p>
  
  <p>But, now I'm trying to do it using django.
  How I can access to a joined model using django???</p>