So it’s not so much Flink itself that was lacking something, but the vendor implementation?

depends on your view i think. the actual function itself was built in to Flink, and i think i would say it's a shortcoming there to not expose it to SQL transforms. then again i probably deal with a lot more hex data than most people