📄️ Introduction to RSQL
DB2Rest uses RSQL or REST SQL to query database tables. RSQL is very easy to learn and write filtering queries.
📄️ Supported RSQL Operators
DB2Rest supports the following RSQL operators.
📄️ Getting Started with Reading Data from Table
The easiest way to retrieve data from a table is to send a GET request with the table name.
📄️ How to apply column filtering on a table?
Column filtering is the ability to specify exactly the columns from the table that should be retrieved in a query.
📄️ How to add column alias?
In the previous section of vertical filtering,
📄️ How to filter rows in a table?
It is possible to filter result rows by adding conditions on columns.
📄️ How to handle large result-sets with Pagination?
Sometimes the result of a query execution can fetch many records. It is inefficient to fetch a large number of row.
📄️ How to sort results?
It is possible order the results retrieved by DB2Rest using the sort request parameter. This will apply ORDER BY
📄️ How to Join Multiple Tables?
When data is stored in a single table, it is very easy to retrieve rows and apply filter.
📄️ How to find one row?
TODO
📄️ How to count the number of rows?
TODO