Update tests to stop using deprecated APIs

[adamcik]

TODO: add a list with things we should cleanup with respect to this after 1.0

[adamcik]

py.test -d --tx '4*popen//python=python2.7 -W error' --boxed has been the methodology so far. Splitting the test across jobs for speed. And using --boxed as warnings filters are global state that seems to keep leaking between tests.

[adamcik]

A gotcha with this has turned out to get not getting the futures while inside the ignore warnings context.

[adamcik]

The empty query case as not been handled by this yet. Rest should be done.

[adamcik]

Leaving this for now as we still have a lot of places we ignore deprecation. And we've not at all touched checking the deprecated properties usage.

[jodal]

Setting milestone to v3.0 as that is the latest we can fix this, since this blocks #1461.