I never tried, but I think it should be possible. The tricky part would be that the function mapping should return the correct type (DataTable?). Please give it a try,
You can use DynamicList or Stored Procedures (the SP call you table-function). Maybe if you post some approximate SQL or some code of the function and what data you can fetch, we can give you some options.