TIBCO BusinessEvents now supports native queries, a native query is a typical query that can be executed using any sql client against the cache. For instance for IGNITE cache , if the query works in a sql client against the space from SQL line or DBeaver or other thin  client then we can use it in BE. A native BQL query is faster than a normal BQL query, but users need to work with the result set differently.

select <field> from <entityURL> as <alias> where <alias>.<field>=<value> ...

select c@id from /Concepts/DemoConcept as c where c.prop_string="testValue"

"native-query: select <field> from be_gen_<entityURLSeparator_underline> where <field>=<value> ...

"native-query: select _id from be_gen_DemoConcept where prop_string="testValue"

• Add prefix "native-query:" to the BQL query to tag the query as a native query.
• Field name for the ID is "_id"
• Field name for the extID  is "_extid"
• Entity URL has a prefix "be_gen_" and the separator "/" replaced with a "_"
• Native queries not work when AS2.x as in-built cache in BE version 6.3.x (AS2.x deprecated)
• For Ignite as in-built cache we recommend to use native queries and add a composite index for the columns in WHERE clause (CDD cluster area -> Overrides section).

try{
	String sQuery = "native-query: select _EXTID from be_gen_concepts_cpTest cp where cp.p1='t2'";
	Object oResultList = Query.Util.executeInDynamicQuerySession(sQuery,null,false);
	Object[] oRows = Query.Util.listToArray(oResultList);
	Query.Util.clearList(oResultList);

	for (int i = 0; i < oRows@length; i++){
		String sExtID=oRows[i];
		// load concept into Rete
		Concepts.cpTest cp=Cluster.DataGrid.CacheLoadConceptByExtIdByUri(sExtID,false,"/Concepts/cpTest");
		System.debugOut(Engine.ruleFunctionName() + " loaded concept with extID=" + sExtID);
	}
}
catch (Exception ex) {
	System.debugOut("### ERROR " + Engine.ruleFunctionName() + ": Stacktrace: " + ex@stackTrace);
}