有没有大佬，求！mapper能实现这样的sql语句吗

[DIANGHONG]

select t.num,t.city,t.wgs84_lng,t.wgs84_lat, TRUNCATE(st_distance_sphere(point (113.8064049, 22.7300434),point(t.wgs84_lng,t.wgs84_lat)),2) as distance from moran_point t where t.city = '深圳' HAVING distance > 0 and distance < 3500 ORDER BY distance;

[abel533]

不能，直接手写效果更好。

[DIANGHONG]

不能，直接手写效果更好。

谢谢解答！