ZCQL

Introduction

ZCQL is Catalyst’s own query language that is similar to MySQL or PostGres. Catalyst supports ZCQL query language to perform data manipulations in the Catalyst Data Store.

You can perform the following operations on the tables in your Data Store using ZCQL:

  • Retrieval: Obtaining records from existing tables
  • Insertion: Inserting records into the existing columns of an existing table
  • Updating: Updating the value of existing columns in an existing table
  • Deletion: Deleting records from an existing table

You can execute a variety of DML queries using ZCQL to obtain or manipulate data based on specific criteria by using various clauses and statements such as the SQL Join clauses, Groupby statements, OrderBy statements, and the WHERE and HAVING clauses. ZCQL also supports several built-in SQL numeric functions that help you execute arithmetic operations easily.

You can implement ZCQL queries in your Catalyst application’s source code, such as in the functions or the client component. For example, you pass a ZCQL query in a function’s body to retrieve data from a table in the Data Store and process it further.

The Catalyst console also provides a ZCQL query execution window, where you can execute queries and view the responses. This allows you to test ZCQL queries easily, before implementing them in your application.

SDK and API documentation

Catalyst offers ZCQL in the Java, Node.js, Python, Web, Android, iOS, and Flutter SDK packages, and as an API. For code samples on executing ZCQL queries in these programming environments, refer to these help pages:

Note:
  • Catalyst will end support for ZCQL V1 Feb 29th, 2024. Only V2 will be available. We recommend that you migrate your existing codebase from V1 to V2. You can find out more about V2’s feature enhancements from this help document.

  • To use ZCQL V2 in your code, you need to set the appropriate environment variable as shown in this help document.

You can refer to Catalyst Tutorials to get an idea of ZCQL’s implementation in the function or client code of the applications.

Benefits

  • Can perform data retrieval, insertion, updating, and deletion operations in the Catalyst Data Store
  • Similarity to MySQL ensures ease of use and there is no separate learning curve
  • Can test the execution of the queries in the console before implementing them in the application
  • Can pass a ZCQL query in an API’s body using the SDKs
  • Can perform arithmetic and numerical operations on the result set using the ZCQL built-in functions

Last Updated 2023-09-02 13:42:08 +0530 +0530