Convert MongoDB query format to SQL query

Question

What I need to do is that I need to convert MongoDB query format (left of =>) that is in JSON string to corresponding SQL query WHERE clause (right of =>)

{ status: "D" }`  **=>** `WHERE status = "D"
{ status: { $in: [ "A", "D" ] } }  **=>**  WHERE status in ("A", "D")
{ $or: [ { status: "A" }, { qty: { $lt: 30 } } ] }  **=>** WHERE status = "A" OR qty < 30
{ $and: [ { status: "A" }, { qty: { $lt: 30 } } ] } **=>** WHERE status = "A" AND qty < 30

Can you please gide me any framework/library that I can use for it? Projetc is in Java language.

framework/library to convert MongoDB to SQL? I'm not sure If I understand your question correctly — eshirvana
– eshirvana, Commented Dec 15, 2020 at 15:22

forgetso · Accepted Answer · 2020-12-15 15:35:35Z

1

You could try the npm package mongo-to-sql-converter, which was designed for this purpose.

Adapting the docs for your question:

var mongoToSqlConverter = require("mongo-to-sql-converter")

const MongoDBQuery = "db.user.find({ $or: [ { status: 'A' }, { qty: { $lt: 30 } } ] });"

const SQLQuery = mongoToSqlConverter.convertToSQL(MongoDBQuery, true)

console.log(SQLQuery)

Putting the above in a script and running with node in the terminal results in

✗ node mongo.js 

SELECT * FROM user WHERE (status = 'A' OR qty < 30);

which seems to be what you're after.

answered Dec 15, 2020 at 15:35

forgetso

2,55420 silver badges38 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Wernfried Domscheit Over a year ago

Better learn how to write queries in MongoDB. This converter covers only the very basic functions. Stuff like NOT IN, =ANY, <>ALL or regular expressions are not converted.

forgetso Over a year ago

The solution covers the examples provided in the question.

forgetso Over a year ago

No. There are libraries to get node code working with java (e.g. trireme) or you could port the code to java as there is very little of it.

Collectives™ on Stack Overflow

Convert MongoDB query format to SQL query

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related