For your Decimal datatype masking, you just need to make sure that your SQL function declaration contains correct datatype. 

Something like: CREATE FUNCTION catalogName.default.my_function(input decimal(x, y)) RETURNS DECIMAL(x, y) RETURN input;

It should work.

On the other hand, my concern is for masking or filtering on sub-field of nested column types like STRUCT or ARRAY.