Conditional SELECT in MySQL with Knex
<p>Is there a way to add IF statements to SELECT queries using Kenx? Let's say that I want to implement the following query:</p>

<pre><code>SELECT id, name, IF(grade&lt;60,'Fail','Pass') AS examResult FROM students;
</code></pre>

<p>Is there a way I could do something like that with Knex without using raw?</p>

<p>Thanks.</p>