[FEAT] As a user, I want to be able to retrieve the email on my orders via GraphQl

[damienwebdev]

💡 Feature request

Feature Name

CustomerOrder.email support.

The Desired Behavior

A new field on CustomerOrder called email that is the same as the email from the sales_order table.

select customer_id, customer_email from sales_order where customer_id is not null;

Your Use Case

As a user, I want to know the email at the time my historical order was placed. Currently, I can only see my current customer's email.

Environment

magento2-daffodil version: 0.61.0
Magento version: v2.4.6-p1
PHP Version version: 8.1