mongo-query-to-postgres-jsonb

mongo-query-to-postgres-jsonb copied to clipboard

The code inserts _partial newline-sensitive matching_ into regex expressions when required. For example, this query: ``` {"name":{ "$regex":"forest"}} ``` correctly leads to: ``` record->>'name' ~ '(\?p)forest' ``` However, when more...

pete-rai

Bumps [shell-quote](https://github.com/substack/node-shell-quote) from 1.7.2 to 1.7.3. Changelog Sourced from shell-quote's changelog. 1.7.3 Fix a security issue where the regex for windows drive letters allowed some shell meta-characters to escape the...

dependabot[bot]

Bumps [ansi-regex](https://github.com/chalk/ansi-regex) from 3.0.0 to 3.0.1. Commits f545bdb 3.0.1 c57d4c2 fix a few old XO issues for backport 419250f Fix potential ReDoS (#37) See full diff in compare view [![Dependabot...

dependabot[bot]

As I can see from test: https://github.com/thomas4019/mongo-query-to-postgres-jsonb/blob/master/test/filter.js#L33 that query like ```json {"roles": {"$elemMatch": "Admin"}} ``` should give SQL like ```js 'data @> \'{ "roles": "Admin" }\'' ``` but if we...

vyacheslav-sozap

Bumps [minimist](https://github.com/substack/minimist) from 1.2.5 to 1.2.6. Commits 7efb22a 1.2.6 ef88b93 security notice for additional prototype pollution issue c2b9819 isConstructorOrProto adapted from PR bc8ecee test from prototype pollution PR See full...

dependabot[bot]

This call ``` mToPsql.convertUpdate('value', { $set: { "Items.0": { test: 0 }, "Items.1": { test: 1 }, "Items.2": { test: 2 }, "Items.3": { test: 3 }, "Items.4": { test:...

vyacheslav-sozap

Bumps [pathval](https://github.com/chaijs/pathval) from 1.1.0 to 1.1.1. Release notes Sourced from pathval's releases. v1.1.1 Fixes a security issue around prototype pollution. Commits db6c3e3 chore: v1.1.1 7859e0e Merge pull request #60 from...

dependabot[bot]

Bumps [cached-path-relative](https://github.com/ashaffer/cached-path-relative) from 1.0.2 to 1.1.0. Commits See full diff in compare view [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter...

dependabot[bot]

Bumps [path-parse](https://github.com/jbgutierrez/path-parse) from 1.0.6 to 1.0.7. Commits See full diff in compare view [](https://docs.github.com/en/github/managing-security-vulnerabilities/about-dependabot-security-updates#about-compatibility-scores) Dependabot will resolve any conflicts with this PR as long as you don't alter...

dependabot[bot]

Match array query doesn't work the same as Mongo

8

Mongo has the ability to search for a specific array value, meaning arrays that have the same elements in the same order: https://docs.mongodb.com/manual/tutorial/query-arrays/#match-an-array If I run a similar query with...

mattbishop