QueryLeaf: Effortlessly Translate SQL Queries to MongoDB Commands

QueryLeaf is a Node.js library that translates SQL queries into MongoDB commands. It parses SQL using node-sql-parser, transforms it into an abstract command set, and then executes those commands against the MongoDB Node.js driver. QueryLeaf supports basic SQL operations (SELECT, INSERT, UPDATE, DELETE) and advanced querying features such as nested field access, array element access, GROUP BY with aggregation functions, and JOINs. It offers multiple interfaces: a library, CLI, and web server. For testing and debugging without a real database, use DummyQueryLeaf.