Node.js Gains Built-In SQLite Full Table Scan Detection via stat() API

Node.js has added native support for detecting SQLite full table scans through two new methods on the StatementSync class: stat() and resetStats(). The feature was inspired by a July post from Aaron Patterson on identifying table scans in Ruby, which prompted developer Kevin Gibbons to open a GitHub issue requesting equivalent functionality in node:sqlite. The implementation exposes SQLite's internal sqlite3_stmt_status() counters to JavaScript, allowing developers to track metrics such as rows scanned, sort operations, and virtual machine steps per query. Because the counters accumulate over a prepared statement's lifetime, resetStats() must be called between measurements to avoid reading a running total. The addition is particularly relevant as AI-generated SQL code may omit indexes without any visible indication, making automated scan detection a useful guardrail in test and development environments.