Actian Matrix (Paraccel) does support UDFs, but you'd have to run your own cluster on premise.

Those who want on-premise Redshift should try Actian Matrix. Redshift is just Amazon's version of Actian Matrix (formerly Paraccel)