Add support for basic SQL group by operations and joins in the SQL Console
I know that you are currently working on expanding the SQL support but if it had the ability to support count(*) and GROUP BY being translated into Aggregation Framework commands and support for joins via $lookup in the new SQL console support in 5.3 it would totally rule.
Dana Groulx commented
I really need to do a join by $lookup as well. I am going to have to try and export to SQL from both collections and join using SQL Server.