Proposal for Missing Operators `OR`, `BETWEEN`, `IS NULL`, `IS NOT NULL`, extending `LIKE`

[eznix86]

OR operator

OR operator is discussed here -> #66

LIKE operator

{"startsWith": "John"}

creates LIKE 'John%'

{"endsWith": "John"}

creates LIKE '%John'

{"contains": "John"}

creates LIKE '%John%'

Note

The current implementation of contains allows %John% to be passed it can be prone to SQL injection

LIKE with CASE INSENSITIVE operator

{"istartsWith": "John"}

{"iendsWith": "John"}

{"icontains": "John"}

Similar as above, but appends collate NOCASE.

BETWEEN operator

{"between": [1, 25]}

IS NULL operator

{"null": true}

IS NOT NULL operator

{"notnull": true}