I am absolutely delighted with this detailed and fast response. This was exactly the information I was looking for. Thanks a lot @jennie258fitz 

Since I was not successful in finding any official information on SQL UDFs, in particular how they compare to the other two, do you happen to have some references, ideally from some official Spark or Databricks source?