Are there any other options to be able to do this?

certainly an rpc call could use a sql function to build it up, maybe a view.

Golden, thank you very much! Working like a charm with the use of rpc function.