Slick utils

RawSqlInstances.scala

import cats.{Contravariant, Functor, Semigroupal}
import slick.jdbc.{
  GetResult,
  PositionedParameters,
  PositionedResult,
  SetParameter
}


trait RawSqlInstances {

  implicit val getResultInstance
      : Functor[GetResult] with Semigroupal[GetResult] =
    new Functor[GetResult] with Semigroupal[GetResult] {

      override def map[A, B](getA: GetResult[A])(f: A => B): GetResult[B] =
        getA.andThen(f)

      override def product[A, B](
          fa: GetResult[A],
          fb: GetResult[B]
      ): GetResult[(A, B)] = GetResult.createGetTuple2(fa, fb)
    }

  implicit val setParameterInstance
      : Contravariant[SetParameter] with Semigroupal[SetParameter] =
    new Contravariant[SetParameter] with Semigroupal[SetParameter] {

      override def contramap[A, B](
          setA: SetParameter[A]
      )(f: B => A): SetParameter[B] =
        (b: B, pp: PositionedParameters) => setA(f(b), pp)

      override def product[A, B](
          fa: SetParameter[A],
          fb: SetParameter[B]
      ): SetParameter[(A, B)] =
        SetParameter.createSetTuple2[A, B](fa, fb)
    }
}
object RawSqlInstances extends RawSqlInstances

SQLActionBuilderInstances.scala

import cats.Monoid
import slick.jdbc.{PositionedParameters, SQLActionBuilder, SetParameter}

trait SQLActionBuilderInstances {

  implicit final val catsMonoidForSQLActionBuilder: Monoid[SQLActionBuilder] =
    new Monoid[SQLActionBuilder] {
      override val empty = SQLActionBuilder(Vector.empty, SetParameter.SetUnit)

      override def combine(
          x: SQLActionBuilder,
          y: SQLActionBuilder
      ): SQLActionBuilder =
        // toVector to avoid List.++ on x.queryParts
        SQLActionBuilder(x.queryParts.toVector ++ y.queryParts.toVector,
                         (p: Unit, pp: PositionedParameters) => {
                           x.unitPConv.apply(p, pp)
                           y.unitPConv.apply(p, pp)
                         })
    }

  implicit final class SQLActionBuilderOps(a: SQLActionBuilder) {

    def ++(b: SQLActionBuilder): SQLActionBuilder =
      Monoid[SQLActionBuilder].combine(a, b)
  }
}

object SQLActionBuilderInstances extends SQLActionBuilderInstances

Obsolete, use https://github.com/kubukoz/slick-effect instead