How To Read Apple Mail Without AppleScript (It's 1000x Faster)

AppleScript for Mail takes 30 seconds to iterate 500 messages. The SQLite envelope index at ~/Library/Mail/V10/MailData/Envelope Index does the same query in 30 milliseconds. Here's the schema, the Apple epoch gotcha, and a working Python script.