mongo-like-query-to-sql

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

Installation

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

Usage

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

./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.