Get the latest tech news
QueryLeaf: SQL for Mongo
SQL for Mongo (in Node JS). Contribute to beekeeper-studio/queryleaf development by creating an account on GitHub.
Multiple interfaces: Library for direct integration in your code CLI for command-line SQL queries Web Server for REST API access PostgreSQL Wire Protocol Server for connecting with standard PostgreSQL clients Basic SELECT queries Filtering with WHERE clauses Sorting with ORDER BY INSERT, UPDATE, and DELETE operations Accessing nested fields with dot notation Accessing array elements with indexing Aggregation with GROUP BY and aggregation functions Joining collections with JOIN syntax SqlParser: Converts SQL text into an abstract syntax tree (AST) using node-sql-parser SqlCompiler: Transforms the AST into MongoDB commands CommandExecutor: Executes the commands against a MongoDB database
Or read this on Hacker News
