The apostrophe is not escaped in this case:
let titleQuery = "it's"
qb.like('s.title', titleQuery, 'both')
The produced SQL has invalid syntax
AND `s`.`title` LIKE '%it's%'
The documentation states:
All fields are escaped automatically, no exceptions.