Consider dropping the dplyr dependency by registering the methods at load time

[ateucher]

Looks good to me. Eventually we also should probably consider dropping the dplyr dependency by registering the methods at load time like arrow does. Thanks for this.

Originally posted by @boshek in #300 (comment)