DataService Studio lets you create APIs in a codeless UI or a code editor. The codeless UI provides a visual interface to configure an API without writing code. The code editor lets you write SQL queries for an API and supports features such as table joins, complex queries, and aggregate functions.
The following table describes the differences between generating an API in the codeless UI and generating an API in the code editor.
Category | Feature | Codeless UI | Code editor |
Query object | Query a single table in a single data source | Support | Support |
Query joined tables in a single data source | Not supported | Supported | |
Query condition | Query an exact number | Supported | Support |
Query a range of numbers | Support | Support | |
Exact string match | Support | Support | |
Fuzzy character matching | Support | Support | |
Query result | Return field values as is | Supported | Support |
Perform mathematical operations on field values | Not supported | Supported | |
Perform aggregate function operations on field values | Not supported | Support | |
Paginate query results | Support | Support | |
Query logic | MyBatis tags | Not supported | Supported |