title: I am receiving the error "Bind variables only allowed in Apex Code [MALFORMED QUERY]" when testing a SOQL statement called from Jitterbit
body: <p>We are using Jitterbit to query records from Salesforce, but we are running into an issue. In the query condition statement I am comparing two fields from the Salesforce table. When I go to test the query, it gives me the error "Bind variables only allowed in Apex Code [MALFORMED QUERY]".</p>
  
  <p>Here is an example of the query:</p>
  
  <pre><code>SELECT Id FROM Price_Agreement_Item__c WHERE Approved_Date__c &gt; Last_Upload_Date__c
  </code></pre>
  
  <p>The fields <code>Approved_Date__c</code> and <code>Last_Upload_Date__c</code> are both contained in Salesforce table <code>Price_Agreement_Item__c</code>. How does one create a SOQL statement that conditions the select statement comparing two fields in the table? </p>
  
  <p>Any help is appreciated.</p>
  
  <p>Thank you in advance.</p>