Is there something like pg_trgm https://www.postgresql.org/docs/current/pgtrgm.html in Pinot?

I don’t think so. this page has all the available fns: https://docs.pinot.apache.org/configuration-reference/functions