chore: deprecate register functionality

[ncclementi]

I think we should remove the register function entirely -- it predates most of the other more specific methods and it's a mess (and is completely untested).

For context see https://github.com/ibis-project/ibis/issues/8728

@gforsyth please add any context that I might have missed here