Hello! In this post about our third EAP build for 2020.3, we'll describe just one feature – but it’s a huge one:
SQL for MongoDB
TL;DR – You can now use SQL to query MongoDB databases.
Only SELECT queries work.
Working сlauses: JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT, OFFSET.
SELECT
Options you can use: DISTINCT, ALL.
You can use aggregate functions: AVG, SUM, MIN, MAX, and others.
Columns can be qualified.
Restrictions
COUNT (expression) is not yet supported.
You can't use aggregate functions, such as AVG, SUM, MIN, and MAX, as if they were not aggregate. For example,