mongo-like-query-to-sql

A tool to convert a mongo-like query to SQL string

Installation

``bash
npm i -s @aggregion/mongo-like-query-to-sql
`

Usage

`javascript
import {objToSQL} from '@aggregion/mongo-like-query-to-sql';

console.log(objToSQL({
$and: [{
$or: [
{age: {$hasAny: [35, 40]}},
{age: {$gte: 20, $lte: 30}},
],
}, {
'settle.population': {$gte: 10000, $lte: 50000},
}],
}));

// Outputs: '(((((hasAny(age, [35, 40]))) OR ((age >= 20 AND age <= 30)))) AND ((settle.population >= 10000 AND settle.population <= 50000)))'
`

Issue a new package version

`bash
./issue.js 1.0.7 # replace with a relevant version number
``

Running the above script in case of success will also trigger a github action automatically publishing new npm package version.