title: How to perform SELECT query on concatenated columns in RoomDB?
body: <p>I have a table(user) with the structure</p>
  
  <pre><code>+-----+----------+------------+
  |ID   |firstName |lastName    |
  +-----+----------+------------+
  |1    |John      |Wesley      |
  +-----+----------+------------+
  |2    |Ashley    |Copper      |
  +-----+----------+------------+
  </code></pre>
  
  <p>Search query 'n W' should results 'John Wesley' and 'y C' should results 'Ashley Copper' out fo the table.</p>