Convert sql to mongodb

This converter is far from done and makes a lots of mistakes!

Online convert sql to mongodb

Sql to convert: select id,salary from table where age >= 20 and (postalCode = 1000 or (lastname = 'johnson' and firstname like '%john%'))

Another sql to mongo converter. Works nicely with group. http://www.querymongo.com

Bitcoin donation: 1K1ausqBJeF6n6pftnrHLcYWecCbSzJnKg

Github: sqltomongodb

Changelog:

• 2012-01-26: make b!=5 into { b : { $ne : 5 } }.
• 2012-01-24: "not" is really working badly.
• 2012-01-18: not improved : makes not b=5 into { b : { $ne : 5 } }
• 2012-01-17: 'not' seems to be working.. (ie. where not a=3 and b=4). (no.. not working anyway. Gives error in mongodb)
• 2012-01-16: Handle like .
• 2012-01-16: Handle is null and is not null.
• 2012-01-16: Use findOne if limit is 1.
• 2012-01-16: Handles count(field).
• 2012-01-13: improved where parsing. Now handles 'and' 'or' and parantheses.
• 2012-01-12: Very simple sql can be converted

To do:

• Make != work
• select distinct
• select a in (x,x,x)
• explain
• update
• group by (argh!)
• delete from
• drop table
• joins (argh!)
• sub selects (argh!)
• insert
• create index