OracleDB supports data redaction for data masking.

Apache Ranger supports data masking for Hive.

Is it possible to setup a filter function for a collection such that all query to this collection will have the returned records pass through this function for dynamic data masking ?

This is an important feature when we need to prepare the data source for exploration by data scientists, but we cannot show them the sensitive data.

Cloning the data for extra proprocessing for this purpose is too painful.