SNOW-1454926: statement.cancel method isn't available anymore in the latest release

[matgott]

Please answer these questions before submitting your issue.
In order to accurately debug the issue this information is required. Thanks!

1. What version of NodeJS driver are you using? 1.11.0

2. What operating system and processor architecture are you using? Ubuntu 20.04.3 LTS 64bits

3. What version of NodeJS are you using?
   node 16.20.2
   npm 8.19.4

4. What are the component versions in the environment (npm list)?

├── @automapper/[email protected]
├── @automapper/[email protected]
├── @automapper/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @nestjs/[email protected]
├── @sendgrid/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @types/[email protected]
├── @typescript-eslint/[email protected]
├── @typescript-eslint/[email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
├── [email protected]
└── [email protected]

5.Server version: xxx

6. What did you do?

With the previous version I was able to do statement.cancel(). Now with version 1.11.0 cancel method is not available in the Statement types RawStatement | FileAndStageBindStatement

7. What did you expect to see?

Being able to cancel a statement

[matgott]

Looking at the code I can see that BaseStatement still has the cancel method but the types are not exposing that so using typescript this won't work:

connection.execute({
  sqlText: "",
  binds: [],
  streamResult: true,
  complete: (err, statement) => {
    if (err) statement.cancel(); // I GET TS ERROR Property 'cancel' does not exist
  }
})

[sfc-gh-dszmolka]

hi and thank you for reporting this issue. seems to be a valid concern indeed. we'll fix it.

[sfc-gh-dszmolka]

PR in progress at #851

[sfc-gh-dszmolka]

PR is now merged and will be part of the next release

[sfc-gh-dszmolka]

released with Snowflake Node.JS driver v1.12.0