Description

Fixes #6319

This PR adds support for the defaultSafeIntegers option in the better-sqlite3 dialect. Previously, this option was passed in the connection configuration but was not being applied to the better-sqlite3 database instance.

This change allows users to enable defaultSafeIntegers: true to receive BigInt values for integers, preventing precision loss for large numbers.

Changes

• Modified acquireRawConnection in lib/dialects/better-sqlite3/index.js to check for defaultSafeIntegers in connection settings or options and apply it to the database instance using db.defaultSafeIntegers().

Related Issue

• This issue was previously raised in Knex does not support better-sqlite3's large integer feature #5050.
• This PR implements the solution suggested in this comment.

Checklist

• Added integration tests
• Updated documentation (if applicable)