This topic describes the two modes for creating APIs and the differences between the modes.

DataService Studio allows you to create APIs in the codeless UI based on tables in relational databases and NoSQL databases. The codeless UI allows you to create APIs without writing code. For more information, see Create an API in the codeless UI.

To meet the personalized query requirements of advanced users, DataService Studio provides a code editor for you to customize SQL statements of APIs. The code editor allows you to use table join queries, complex queries, and aggregate functions. For more information, see Create an API in the code editor.

The following table describes the differences between the codeless UI and code editor.
Category Feature Codeless UI Code editor
Query object Query a single table in a single data store Supported Supported
Query joined tables in a single data store Not supported Supported
Query condition Query an exact number Supported Supported
Query a range of numbers Supported Supported
Query a string in exact match mode Supported Supported
Query strings in fuzzy match mode Supported Supported
Query result Return field values without changes Supported Supported
Return a mathematical calculation of field values Not supported Supported
Return an aggregate calculation of field values Not supported Supported
Return results on multiple pages Supported Supported