I am attempting to test a query being used in an external application with salesforce integration where this query was generating a 'malformed query' error but I am running into an issue where the query is causing the error in the question title to be thrown in the dev console to be thrown.
Here is the query:
select field1,field2 from Account where not field1 like '%GEN' and field2 != null
Is it not possible to use multiple where conditions with 'like' in SOQL? If so are there any workarounds other than using two queries for this use case (not practical for the external application)?
Some background info on the external application in question, it has a Salesforce plugin which uses Salesforce SOQL query language to generate API calls to fetch data into the running job.