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.
Options you can use: DISTINCT, ALL.
You can use aggregate functions: AVG, SUM, MIN, MAX, and others.
Columns can be qualified.
COUNT (expression) is not yet supported.
You can't use aggregate functions, such as AVG, SUM, MIN, and MAX, as if they were not aggreg