Idea Summary
Smart Filters apply search operators to inputs against column data, for instance for “Equals”:

COLUMN_DATA = SEARCH_TERM

If I was building the search query myself, I could do something like the following to ensure matching:

upper(COLUMN_DATA) = upper(SEARCH_TERM)

For my actual scenario I would like to strip the punctuation in the search term:

some_function(COLUMN_DATA) = some_function(SEARCH_TERM)

I can do this for the COLUMN_DATA easy enough but have nowhere to define some_function() for the Smart Filter.

Preferred Solution
I would like to be able to define a PL/SQL expression against the Smart Filter which the SEARCH_TERM is passed through before being used in the rest of the process.

Or, as the removal of punctuation is probably a common requirement a new option below ‘Case Sensitive’ which handles it for me.

Ideally… both, so I know I have complete control of what gets passed as the SEARCH_TERM if I need it.