Add ST_Translate(geography, ...)

[strk]

I think it'd make sense to add ST_Translate support for "geography". First implementation could just be doing roundtrip reprojection.

[pramsey]

This is a lot less obvious that something like ST_Buffer, because translate is very sensitive to what the cartesian system actually is. A translate that ends up round-tripping into polar stereographic, for example, could provide very surprising results to people!

A more deterministic variation would be to make ST_Project accept geometry types other than point. The whole object would be moved the desired distance and direction, which is what people translating generally want, no?

[strk]

I actually forgot the use case that got me open this ticket. Feel free to close if you don't feel the need of it.

[robe]

I don't feel the need for it.