Select paginated data from database

Fetch multiple items from database with build in pagination

Select paginated

{
  "type": "sql-select-paginated",
  "id": "products-paginated",
  "connection": "sample-database-connection",
  "query": "SELECT * FROM `product` limit :offset, :limit",
  "queryCount": "SELECT count(*) as c FROM `product`",
  "params": [
    {
      "name": "limit",
      "type": "int",
      "default": 10,
      "required": true
    },
    {
      "name": "page",
      "type": "int",
      "default": 1,
      "required": true
    }
  ]
}

Every sql-select-paginated query must contain (:page, :limit) or :offset params, they are special, created and calculated by the system