DataService Studio memungkinkan Anda membuat API melalui antarmuka tanpa kode atau editor kode. Antarmuka tanpa kode menyediakan antarmuka visual untuk mengonfigurasi API tanpa menulis kode, sedangkan editor kode memungkinkan Anda menulis kueri SQL untuk API serta mendukung fitur seperti penggabungan tabel, kueri kompleks, dan fungsi agregat.
Tabel berikut menjelaskan perbedaan antara menghasilkan API di antarmuka tanpa kode dan menghasilkan API di editor kode.
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 |