No, the query builder cannot do sub queries, you would need to do those manually.
at this time eCart is updated to Support MySQLi, we are working on Data Bridge, targeting the first quarter of next year for that, then will do Design Extender.
We will have MySQLi added to the drop down soon.