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

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 customizing 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 Not supported Supported
Query a string in exact match mode Supported Supported
Query strings fuzzy match in fuzzy match mode Supported Supported
Query result Return field values without any 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