ZCQL

ZCQL is Catalyst's own query language that enables you to perform data retrieval, insertion, updating, and deletion operations on the tables in the Catalyst Data Store. You can execute a variety of DML queries using ZCQL to obtain or manipulate data, and use various clauses and statements such as the SQL Join clauses, Groupby and OrderBy statements, and built-in SQL functions.

Execute ZCQL Queries

You can retrieve, insert, update, or delete data from a table in the Data Store by writing a query for it. The ZCQL query is constructed and passed to the executeQuery() method for execution. The response will contain the records you fetch using the SELECT query, or the response generated for the other operations.

Ensure the following packages are imported:

Copiedimport com.zc.component.object.ZCRowObject; 
import com.zc.component.zcql.ZCQL;

Copied//Construct the query to be executed
String query = "select * from empDetails limit 10";
//Get the ZCQL instance and execute query using the query string
ArrayList<ZCRowObject> rowList = ZCQL.getInstance().executeQuery(query);