Specifies whether to allow SOQL queries to be passed directly to Salesforce instead of translating SQL queries into SOQL.

Data Type

bool

Default Value

false

Remarks

By default, the component accepts SQL queries and automatically translates them into SOQL before sending them to Certinia. This allows users to work with familiar SQL syntax while the driver handles query translation.

When QueryPassthrough is set to true, the component accepts SOQL queries directly and send them to Certinia without translation. This is useful for advanced users who prefer to write native SOQL to take full advantage of Salesforce-specific query capabilities that may not be easily expressed in SQL.

Using passthrough mode gives users full control over query structure and enables access to advanced SOQL features. However, this requires knowledge of SOQL syntax, and invalid queries are not corrected or translated by the component. Enabling this property can be beneficial for complex queries that are difficult to construct in SQL, but for general use, SQL-to-SOQL translation remains more user-friendly.

This property is useful for advanced users who are comfortable writing SOQL and need direct control over queries sent to Salesforce.