@karlenigma I discovered entity search which lets me search across multiple entities. What I want to do is create a search that lets me get leads, contact and opportunities for an email campaign. What I would like to do is write some SQL join type syntax instead of using the clunky expression builders.