json-sql-builder2 icon indicating copy to clipboard operation
json-sql-builder2 copied to clipboard

Compatibility with MongoDB

Open yanickrochon opened this issue 5 years ago • 2 comments

What is the state of this project regarding supporting MongoDB features? This is by far the most comprehensive project I have seen offering a somewhat compatible syntax, and I'd be willing to contribute in adding missing helpers and operators.

Was this why this project have been created, or was the idea to support yet another subset of JSON queries? And if so, why can't it be made to be an adapter layer between MongoDB queries and SQL queries?

I understand the limitations of both specifications, and I wouldn't expect everything to be supported, but having these features would allow projects to integrate SQL with NoSQL more easily, and it seems like this project has already the foundations for this.

yanickrochon avatar Mar 10 '20 16:03 yanickrochon

Sorry for my late answer. I wrote this lib because i worked with MeteorJS and Try to change the mongo DB to postgres with livequeries.

planetarydev avatar Mar 31 '20 19:03 planetarydev

Hi @planetarydev, thank you for the response. I actually started a project about two weeks ago with the goal of supporting Collections with SQL. The project is really early and mostly unknown still, but it is inspired upon this project as well as another project. If you're interested to take a look : https://gitlab.com/mind2soft/maysql

yanickrochon avatar Mar 31 '20 19:03 yanickrochon