No, you would have to copy/paste sections of the query.
The posts table in the database includes a via_email boolean, so yes you can find out which posts were created via email 
However, Discourse doesnât include any trackers in the emails it sends, so there wonât be any way to determine whether an email notification has been âreadâ or not