title: Symfony3 - Using LEFT or RIGHT with doctrine
body: <p>From my names table containing values <code>id, firstName, lastName</code> I want to take out all rows, <strong>but</strong> from the <code>firstName</code> I just want the first letter.</p>
  
  <p>I know I can make custom mySql query with doctrine but was wondering is there a more....well docrtine way to do such things (and other value select operations).</p>
  
  <p>What could be the way to do it with solely doctrine?</p>
  
  <p>An option to get the full string and then cut it in php is out of the question.</p>