title: Raw query inside entity
body: <p>I am making a twitter clone.</p>
  
  <p>The join table creates a <code>following</code> table with a <code>user_id</code> and <code>follower_id</code></p>
  
  <pre><code>@ManyToMany(fetch = FetchType.EAGER, cascade = [CascadeType.PERSIST])
  @JoinTable(
          name = "following",
          joinColumns = [(JoinColumn(name = "user_id", referencedColumnName = "id"))],
          inverseJoinColumns = [(JoinColumn(name = "follower_id", referencedColumnName = "id"))]
  )
  var following: List&lt;User&gt; = emptyList()
  </code></pre>
  
  <p>The following query gives me my followers</p>
  
  <pre><code>SELECT * FROM users WHERE id = (SELECT user_id FROM following WHERE `follower_id` = 1)
  </code></pre>
  
  <p>How can I implement this query in my entity?</p>