knn ordering with <->

[berndhopp]

k-nearest-neighbour ordering is implemented in postgis https://postgis.net/workshops/postgis-intro/knn.html
would it make sense to introduce the knn order operator <-> as a custom jpql operator in hibernate spatial? on the one hand, it seems to be a useful feature, on the other hand it is not supported on mysql and mariadb AFAICS.

[gavinking]

This seems to me like a perfect case for just registering a function (which is very easy to do). I would not introduce a new operator into HQL for this.

[beikov]

I agree, just use a function