Hello,
This is not possible from within EV or SQL. Specific item information like you indicate is stored in the indexes, not in the archive information itself. The only option I can think of is if you have Discovery Accelerator.
You can then run a search against 1 archive. When done, export the resultset. this will create 3 additional files (after the export completes) (html, txt, xml) where at least the txt file contains such info. This will show (amongst other information) Author, Subject, Content, Mail Date, NumAttachments and the Original Location (in the mailbox)