Integration with knex.js bindings not working as expected

[mandaputtra]

Current Behavior

When I use the query like this

await knex.raw("select * from users where email = '[email protected]'")

I get result as expected, but when I'm doing this I got no result at all

await knex.raw("select * from users where email = ?", ['[email protected]'])

// or

await knex('users').where('email', '[email protected]')

I'ts returned with undefined, or no result. The debug result seems fine. So I don't know what's going on internally. Here is the debug result:

{
  method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [ '[email protected]' ],
  __knexQueryUid: '9DzRy-hEBsxEfjGYmLt9p',
  sql: 'select * from `users` where `email` = ?'
}

Expected Behavior

Should result in finding the row

Steps to Reproduce the Problem

1. Use example of integrations on Knex here
2. Use bindings or anything else that requires bindings
3. See no result

Environment

• Version: "@sqlitecloud/drivers": "^1.0.406", "knex": "^3.1.0",
• Platform: MacOS
• Node.js Version: 20.x.x

[Gioee]

Hi @mandaputtra
We've fixed this issue, we'll ship the new version with the fix in a few hours on npm.
Thank you for all the details that helped us find the problem.

[Gioee]

Hi @mandaputtra ,
This bug has been fixed in version 1.0.417