With a little help from the folks over at the Views project, I got that issue worked out. It turns out I was missing a needed call of $query->ensure_table().

I will keep working on this integration and I will post updated code when I am further along. In the meantime, does anyone have any feature or implementation requests? I will see if I can get them working along with the rest of the integration.