DirtyTrick.scala

val ss: SparkSession
val df: DataFrame

import ss.implicits._


trait NotTypeColumn[C]

object NotTypeColumn {
  implicit def notc[C <:  org.apache.spark.sql.Column]:NotTypeColumn[C] = new NotTypeColumn[C] {}
  implicit def notc1[A,B]:NotTypeColumn[org.apache.spark.sql.TypedColumn[A,B]] = ???
  implicit def notc2[A,B]:NotTypeColumn[org.apache.spark.sql.TypedColumn[A,B]] = ???
}


object Ops  {

  implicit class ColumOps[C <: org.apache.spark.sql.Column]
  (val c: C)(implicit not:NotTypeColumn[C]) {
    def |>[A, B](f: A => B): org.apache.spark.sql.TypedColumn[Any, B] = ???
  }


  implicit class TypeColumnOps[A, B](val tc: org.apache.spark.sql.TypedColumn[A, B]) {
    def |>[C](f: B => C): org.apache.spark.sql.TypedColumn[A, C] = ???
  }

}

import Ops._

   df.select($"name".as[String] |> (_ + "!"))

   df.select($"name" |> ((x: String) => x + "!"))