Under Raw Parameter Binding, the docs say:

To prevent replacement of ? one can use the escape sequence \\?

The docs give this example:

knex.select('*')
  .from('users')
  .where('id', '=', 1)
  .whereRaw('?? \\? ?', ['jsonColumn', 'jsonKey'])

Expected behavior

The knex raw function should replace all escaped "\\?" with "?".

Actual behavior

But if you debug the result of that example, you'll see:

{
  method: 'select',
  options: {},
  timeout: false,
  cancelOnTimeout: false,
  bindings: [ 1, 'jsonKey' ],
  __knexQueryUid: 'G2s8qdeLVgEWhFUNJwjgP',
  sql: 'select * from "users" where "id" = ? and "jsonColumn" \\? ?'
}

Notice that the escaped "\\?" left intact in the generated sql which will produce a syntax error.

Solution

Change this line to return "?".