PyCharm
 
Get PyCharm

SQL for MongoDB

Last modified: 29 August 2024

In MongoDB, to manipulate data or perform other operations, you write scripts for the mongo shell in JavaScript. For developers who query data primarily with SQL, it might be helpful to use SQL for MongoDB collections as well. PyCharm will translate your SQL queries to JavaScript.

  • To see the JavaScript version of SQL, right-click a query and select Show JS Script.

  • The current implementation supports SELECT queries and the following сlauses: JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET.