Zoho CloudSQL Developer Information

Zoho CloudSQL extends the HTTP based Web APIs offered by each Zoho Service and offers SQL support over it. You just have to construct the SQL queries and pass them as POST request payload in the API calls.

SQL Query Syntax:

The SQL query syntax should be the same as defined in the SQL Standard. In addition, Zoho CloudSQL will support SELECT, INSERT, UPDATE and DELETE SQL statements written in any of ANSI, Oracle, Microsoft SQL Server, IBM DB2, MySQL, PostgreSQL and Informix database dialects. Refer to the ANSI SQL Language documentation or the respective relational database documentation for the SQL Language syntax.

SQL Query Entity Mapping:

To construct an SQL query you need to have the entities called Database, Tables and Columns defined. With these entities an SQL query is constructed and executed.

The entities i.e. Database, Tables and Columns based on which the SQL query is constructed depends on the specific Zoho Service on which the SQL query is to be executed. For example in Zoho Reports (previously known as Zoho DB & Reports) the mapping of the entities would be the following: