With knexjs, how do I compare two columns in the .where() function? : <p>Using knexjs only (no bookshelf) I would like to do something like the following query:</p>

<pre><code>select * from table1 where column1 &lt; column2
</code></pre>

<p>However, when I do this:</p>

<pre><code>.table("table1").select().where("column1", "&lt;", "column2")
</code></pre>

<p>The SQL that knexjs generates is:</p>

<pre><code>select * from table1 where column1 &lt; 'column2'
</code></pre>

<p>Which doesn't give the desired result b/c it's not comparing the value from the column, it's comparing the value of the string, 'column2'.</p>

<p>Anyone know how to do what I'm wanting? Thanks!</p>
