where-in-json

A JavaScript library to convert a json filter to SQL Where Clause.

How to use

const parser = require('where-in-json');

Example 1

const filter = {
    name: 'John',
    email: '[email protected]',
    contactNo: 1231231230
};

console.log(parser.toWhereClause(filter));

//OUTPUT: name='John' AND email='[email protected]' AND contactNo=1231231230

Example 2

const filter = {
    $and: [
        { name: 'John' },
        {
            $or: [
                { email: '[email protected]' },
                { contactNo: 1231231230 }
            ]
        }
    ]
};

console.log(parser.toWhereClause(filter));

//OUTPUT: (name='John' AND (email='[email protected]' OR contactNo=1231231230))

Example 3

const filter = {
    name: 'John',
    $or: [
        {
            email: {
                $ne: '[email protected]'
            }
        },
        { contactNo: 1231231230 }
    ]
};

console.log(parser.toWhereClause(filter));

//OUTPUT: name='John' AND (email <> '[email protected]' OR contactNo=1231231230)

Example 4

const filter = {
    name: 'John',
    age: {
        $and: [
            { $gte: 18 },
            { $lte: 25 }
        ]
    }
};

console.log(parser.toWhereClause(filter));

//OUTPUT: name='John' AND (age >= 18 AND age <= 25)

Example 5

const filter = {
    $and: [
        { name: 'John' },
        {
            age: { $gte: 18 }
        },
        {
            age: { $lte: 25 }
        }
    ]
};

console.log(parser.toWhereClause(filter));

//OUTPUT: (name='John' AND age >= 18 AND age <= 25)