This extends explicit resource management support to prepared
statements, allowing a StatementSync to be deterministically
finalized via a `using` declaration, mirroring the existing
DatabaseSync and Session dispose methods.

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

Statements could only be finalized by garbage collection or by closing the
database, so there was no way to release one deterministically and `using
stmt = db.prepare(...)` did nothing.

close() finalizes the statement and stops the database tracking it. It throws
ERR_INVALID_STATE if the statement is already finalized, if it is currently
executing, or if it is called from inside an authorizer callback: finalizing a
statement whose sqlite3_step() is on the stack is undefined behavior, and
sqlite3_finalize() modifies the connection, which SQLite forbids from an
authorizer. That second guard is what every other statement method already
does, and is an intentional divergence from node:sqlite, which has no
authorizer guard at all.

Symbol.dispose never throws, so both unsafe cases become no-ops there and the
statement is finalized later by GC or database close.

Also drops FinalizeStatement() and FinalizedGetter(), which were never
registered on the prototype and so were unreachable.

Ports nodejs/node#64232.

This extends explicit resource management support to prepared
statements, allowing a StatementSync to be deterministically
finalized via a `using` declaration, mirroring the existing
DatabaseSync and Session dispose methods.

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

This extends explicit resource management support to prepared
statements, allowing a StatementSync to be deterministically
finalized via a `using` declaration, mirroring the existing
DatabaseSync and Session dispose methods.

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

Signed-off-by: Guilherme Araújo <arauujogui@gmail.com>
PR-URL: #64232
Reviewed-By: René <contact.9a5d6388@renegade334.me.uk>

Notable changes:

benchmark:
  * (SEMVER-MINOR) add --analyze mode to compare.js (James M Snell) #65416
crypto:
  * update root certificates to NSS 3.126 (Node.js GitHub Bot) #65495
  * (SEMVER-MINOR) enable SIV and GCM-SIV modes in Cipher/Decipher APIs (Filip Skokan) #63411
diagnostics_channel:
  * mark TracingChannel as stable (Abdelrahman Awad) #64525
lib,src:
  * (SEMVER-MINOR) improve histogram implementation (James M Snell) #65024
net:
  * (SEMVER-MINOR) improve performance of net.BlockList (James M Snell) #64974
perf_hooks:
  * (SEMVER-MINOR) add statistical hypothesis testing to histogram (James M Snell) #65416
repl:
  * add basic syntax highlighting (Aviv Keller) #64591
sqlite:
  * (SEMVER-MINOR) add StatementSync.prototype.close() (Guilherme Araújo) #64232
  * (SEMVER-MINOR) add StatementSync.prototype[Symbol.dispose]() (Guilherme Araújo) #64232
util:
  * (SEMVER-MINOR) add non-throwing MIMEType.parse (James M Snell) #64965
zlib:
  * (SEMVER-MINOR) add ZipEntry, ZipFile, and ZipBuffer (Philipp Dunkel) #64339

PR-URL: #65551