custom query when retrieving items with mod_flexicontent

I would need to add a custom query when retrieving items with mod_flexicontent. How would that be done best in a custom template?

My query is:
SELECT *,( 6371 * acos( cos( radians({$lat}) ) * cos( radians( `lat` ) ) * cos( radians( `lng` ) - radians({$lng}) ) + sin( radians({$lat}) ) * sin( radians( `lat` ) ) ) ) AS distance
FROM `positions`
HAVING distance <= {$radius}
ORDER BY distance ASC

Cheers

Hello

currently custom SQL query is not supported

Thank you for the quick response. I know it is not supported, that is why I asked how to do it in a custom template. Maybe you can help me with that.

Cheers

Hello

the queries are done inside the helper file so if you do it at the template you have to redo a lot of code, and i will not tell you to hack helper.php

- since you ask if possible, anything is possible if given time and effort

only choice is a developer choice : duplicate/rename the module, and modify it

Regards

Ok, thanks, I was already afraid to hear exactly that answer

Is there any plan on making custom queries available in the backend of the module? Just asking if I should wait before I duplicate/rename the module.

Cheers

maybe you can paid for specific dev ?