Support for postgres ilike operator

[iyerushalmi]

Is there any way to easily swap out the "like" operator with an "ilike" operator for postgres databases? I am looking to implement case insensitive searches

[mistic100]

$(....).queryBuilder({
  .......,
  sqlOperators: {
        begins_with:      { op: 'ILIKE(?)' },
        not_begins_with:  { op: 'NOT ILIKE(?)' },
        contains:         { op: 'ILIKE(?)' },
        not_contains:     { op: 'NOT ILIKE(?)' },
        ends_with:        { op: 'ILIKE(?)' },
        not_ends_with:    { op: 'NOT ILIKE(?)' },
  }
});

If you want to use LIKE as well you need to create new operators http://querybuilder.js.org/#operators and configure them (reference: https://github.com/mistic100/jQuery-QueryBuilder/blob/master/src/plugins/sql-support/plugin.js)

[iyerushalmi]

Amazing , thank you! The only thing I am wondering now is how to build compatibility with the SQL Parser but I am guessing that may not be within the scope of this forum?

[mistic100]

You can propose changes https://github.com/mistic100/sql-parser