Salesforce Lookup Feature Issues with Opportunity Records

Hi Clay Team - I'm having issues with the Salesforce lookup feature with Opportunity records and I'd like to find a native way to run lookups that contain conditions (i.e. lookup Opportunities associated with X Account ID that are open). is the only way to accomplish this with a SOQL query? Would be great to have filtering logic on the native Salesforce lookup as that's been a great tool for me so far. and am running into a bunch of errors with SOQL. Appreciate any advice!