Hello.

I had the exact same problem.

Solution: created a stored procedure which calls the user-defined function. Then, call the stored procedure from the Lookup Query (exec SPNAME ?)

(not very elegant, but worked at...