Theconn.bulk.query() method was failing with error "No sobject type found in query" when queries contained parentheses in both SELECT and WHERE clauses. This was caused by a greedy regex that removed too much content from the query string.

Problem

The original regex/\([\s\S]+\)/g was designed to remove parenthesized content (like subqueries) to extract the main sobject type from the FROM clause. However, it used a greedy quantifier that matched from thefirst opening parenthesis to thelast closing parenthesis, which could remove the entire FROM clause in queries like:

SELECT x, y, (SELECT IdFROM SubObject1), (SELECT IdFROM SubObject2)FROM MyObject__cWHERE ((a=1AND b=2)OR c=3)

The regex would remove everything from(SELECT Id FROM SubObject1) throughOR c = 3), leaving onlySELECT x, y, and causing the FROM clause extraction to fail.

Solution

Replaced the single greedy regex with an iterative approach that removes parenthesized content level by level:

// Before (problematic)constm=soql.replace(/\([\s\S]+\)/g,'').match(/FROM\s+(\w+)/i);// After (fixed)letcleanedSoql=soql;while(/\([^()]*\)/.test(cleanedSoql)){cleanedSoql=cleanedSoql.replace(/\([^()]*\)/g,'');}constm=cleanedSoql.match(/FROM\s+(\w+)/i);

This approach correctly handles:

• Multiple subqueries in SELECT clause
• Nested parentheses in WHERE conditions
• Complex nested subqueries
• All existing simple cases

Testing

Added comprehensive test cases covering:

• The original problematic query from the issue
• Nested parentheses scenarios
• Simple queries (regression testing)
• Single subquery cases

All existing functionality remains unchanged, and the fix is minimal with only 8 lines of code modified.

Fixes#671.

💬 Share your feedback on Copilot coding agent for the chance to win a $200 gift card! Clickhere to start the survey.