REST query for a service with composite key returns an error in postman Incorrect syntax near ','

[haniyasin]

Summary : auto generated query to count is not compatible with MSSQL
it should be something like : select count (*) from ( select distinct CompanyID, DivisionID,DepartmentID,OrderNumber from orderheader )AS sub

---

Postman request URL:
http://localhost:3030/orderheader?companyid=Dinos&divisionid=default&departmentid=default

error result(postman):
"name": "GeneralError",
"message": "select count(distinct [orderheader].[CompanyID], [orderheader].[DivisionID], [orderheader].[DepartmentID], [orderheader].[OrderNumber]) as [total] from [orderheader] where [companyid] = @p0 and [divisionid] = @p1 and [departmentid] = @p2 - Incorrect syntax near ','.",
"code": 500,
"className": "general-error",
"errors": {}
}

service options:
const options = {
Model: createModel(app),
paginate: app.get('paginate'),
id:['CompanyID','DivisionID','DepartmentID','OrderNumber']
};

Connection :
const client = 'mssql'
const connection = {
user: 'enterprise',
password: 'enterprise',
server: 'localhost',
database: 'enterprise',
port: 1433,
//debug: true,
options: {
encrypt: false
}
}

Dependencies:
"dependencies": {
"@feathersjs/authentication": "^4.5.14",
"@feathersjs/authentication-local": "^4.5.14",
"@feathersjs/authentication-oauth": "^4.5.14",
"@feathersjs/configuration": "^4.5.12",
"@feathersjs/errors": "^4.5.12",
"@feathersjs/express": "^4.5.14",
"@feathersjs/feathers": "^4.5.12",
"@feathersjs/socketio": "^4.5.14",
"@feathersjs/transport-commons": "^5.0.0-pre.20",
"compression": "^1.7.4",
"cors": "^2.8.5",
"feathers-objection": "^7.5.3",
"helmet": "^4.6.0",
"knex": "^2.0.0",
"mssql": "^8.1.0",
"objection": "^3.0.1",
"serve-favicon": "^2.5.0",
"winston": "^3.7.2"
},