builder

Implement a query builder on top of the client.

See this stackoverflow post for info on how to properly do case-insensitive text search in SQL by using the COLLATE keyword. Note: Collate is not avaialble in knexQuerry builder

Regex in the different Databases:

• MySql: Use REGEXP statement, example: WHERE aut_name REGEXP '^w';
• Potgres: LIKE opperator should do it, but better is: ~ see:this post
• SQLLite3: Regex is not by default in SQLLite3. "It defines a REGEXP operator, but this will fail with an error message unless you or your framework define a user function called regexp()" see this post