PyCharm
 
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.

SQL for MongoDB

Last modified: 20 September 2023

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.