title: "AS" equivalent in sqlite
body: <p>I'm a beginner with sqlite coming from mysql.
  maybe my question is dumb but I can't find the equivalent of the "AS" in mysql for example.</p>
  
  <p>Example: <code>"SELECT firstName || ' ' || lastName AS fullName FROM myTable;"</code></p>
  
  <p>Is it possible?</p>
  
  <p>Thanks in advance!</p>