Getting Error: Parameterized views can't be used with...

[#1]

When I run cds watch --profile hybrid on my CAPM project the following error is popping up

Error: Parameterized views can't be used with sqlDialect ‘sqlite’

But the cds deploy --to hana works perfectly fine and all the artifacts are deployed. I am using HANA for db side. Below is the package.json for the project

{ "name": "xxxxxx", "version": "1.0.0", "description": "A simple CAP project.", "type": "module", "dependencies": { "@cap-js-community/odata-v2-adapter": "^1.15.10", "@cap-js/hana": "^2", "@sap/cds": "^9", "@sap/xssec": "^4", "exceljs": "^4.4.0" }, "devDependencies": { "@sap/cds-dk": "^9" }, "scripts": { "start": "cds-serve" }, "private": true, "cds": { "requires": { "[production]": { "auth": "xsuaa" }, "db": { "kind": "hana" } } } }

[UtkarshAgrawal]

Hi, this is not working still. For context, I want to use hana for local development also (we have several things that work with hana only like parameterized calculation views as specified in the question). Attaching the package.json below.

{
  "name": "xxxx",
  "version": "1.0.0",
  "type": "module",
  "dependencies": {
    "@cap-js-community/odata-v2-adapter": "^1.15.10",
    "@cap-js/hana": "^2",
    "@sap-cloud-sdk/http-client": "^4.6.0",
    "@sap/cds": "^9",
    "@sap/xssec": "^4",
    "crypto-js": "^4.2.0",
    "xml2js": "^0.6.2"
  },
  "devDependencies": {
    "@sap/cds-dk": "^9"
  },
  "scripts": {
    "start": "cds-serve"
  },
  "private": true,
  "cds": {
    "requires": {
      "[production]": {
        "auth": "xsuaa"
      },
      "db": "hana"
    },
    "[hybrid]": {
      "requires": {
        "db": {
          "kind": "hana"
        }
      },
      "sql": {
        "dialect": "hana"
      }
    }
  }
}