Is there a CLI front-end to the Contacts.app (formerly Address Book.app) database?
mycontacts --email '*@google.com' # to get Googlers
Contacts still has AppleScript support. You can see documentation for the supported properties and commands by opening its dictionary in AppleScript Editor.
I didn't find a way to check the actual email fields using a single specifier.