I would like to understand how

(1) SQL UDFs compare to Python UDFs

(2) SQL UDFs compare to Pandas UDFs

Especially in terms of performance.

I cannot find any documentation on the topics, also not in the official Databricks documentation (which unfortunately is kind of a pattern).

I do not need information regarding the comparison between Python UDFs and Pandas UDFs though.

Thanks in advance!