Using Database Views with Case Statements to Vastly Improve App Performance

I’m working on creating some more complex database queries in my app and I want to make sure I understand the limits of a normal Wappler Database Query before I move to making custom ones.

The question is my mind is whether I can create aggregates in a Database Query which are based on a value returned by a stored function, so to use the Database Query action which works the same as this:

select id, my_stored_function (response, response_type) as this_response from responses where id=:P1;

or to achieve something like this would I need to use a custom query?