DataWeave supports nested SOQL queries, which improves development time and enables easy integration and efficiency with your transformations. We delivered this feature due to your idea on IdeaExchange.
Where: This feature is available in API version 66.0 and later. This feature is available in Lightning Experience and Salesforce Classic in Enterprise, Performance, Unlimited, and Developer editions.
How: Previously, when performing transformations involving subqueries or nested SOQL queries with parent-child relationships, Apex failed with a DataWeaveScriptException.