How to Make entities with parameter support with Sqlite When running CAPM locally

[#1]

Hi,

I am new in SAP stuffs. Recently I do a CAPM project using Node.js. The project runs very well when deployed. But When I run the project locally, I received an error : Entities with parameters are only supported on HANA. Because I have 2 Views which require parameter.

As I know, when we run locally for development, then it should be deployed to slite memory database. Since sqlite cannot support view with parameter, therefore I am asking if there will be same way to avoid this error when running locally ?

Here is the package json

{
  "name": "POC",
  "version": "1.0.0",
  "description": "A simple CAP project.",
  "repository": "<Add your repository here>",
  "license": "UNLICENSED",
  "private": true,
  "dependencies": {
    "@sap/cds": "^4",
    "@sap/hana-client": "^2.6.61",
    "axios": "^0.21.1",
    "dotenv": "^8.2.0",
    "express": "^4",
    "hdb": "^0.18.2"
  },
  "devDependencies": {
    "@sap/hdi-deploy": "^3.11.5"
  },
  "scripts": {
    "start": "cds run"
  },
  "cds": {
    "features": {
      "fiori_preview": true
    },
    "hana": {
      "deploy-format": "hdbtable"
    },
    "requires": {
      "db": {
        "kind": "sql" // I TRIED to change to "Hana", no error received but the odata endpoint doesn't work
      }
    }
  }
}

[gregorw]

You can use HANA Express DB only for local development.