where-in-json
A JavaScript library to convert a json filter to SQL Where Clause.
How to use
const parser = ;
Example 1
const filter = name: 'John' email: 'John@doe.com' contactNo: 1231231230; console; //OUTPUT: name='John' AND email='John@doe.com' AND contactNo=1231231230
Example 2
const filter = $and: name: 'John' $or: email: 'John@doe.com' contactNo: 1231231230 ; console; //OUTPUT: (name='John' AND (email='John@doe.com' OR contactNo=1231231230))
Example 3
const filter = name: 'John' $or: email: $ne: 'John@doe.com' contactNo: 1231231230 ; console; //OUTPUT: name='John' AND (email <> 'John@doe.com' OR contactNo=1231231230)
Example 4
const filter = name: 'John' age: $and: $gte: 18 $lte: 25 ; console; //OUTPUT: name='John' AND (age >= 18 AND age <= 25)
Example 5
const filter = $and: name: 'John' age: $gte: 18 age: $lte: 25 ; console; //OUTPUT: (name='John' AND age >= 18 AND age <= 25)