Hello MtnPavlas,
yes, in the Afterstore you can do what you want.
Like you wrote, you can make a request on database to get recipient emails and update the desired email field. By cons, for that, the Field Code must be put before the email field because in an email field, emails are send in the afterstore event.
Regards.
Lionel