Select non paginated data from database

Fetch single or multiple items from database without using pagination

Select

{
  "type": "sql-select",
  "id": "products-by-id",
  "connection": "sample-database-connection",
  "query": "SELECT * FROM `product` where id IN(:id)",
  "resultType": "list",
  "params": [
    {
      "name": "id",
      "type": "int",
      "required": true,
      "list": true,
      "default": [0]
    }
  ]
}