knexjs search uppercase

JavaScript
qb.whereRaw(`LOWER(name) LIKE ?`, [`%${search}%`])
Source

Also in JavaScript: