scalikejdbc back-quoted syntax

MySQLSyntaxSupport.scala

import scalikejdbc._

object MySQLSyntaxSupport {

  implicit class RichInsertSQLBuilder(val self: InsertSQLBuilder) extends AnyVal {

    def quotedNamedValues(columnsAndValues: (SQLSyntax, ParameterBinder)*): InsertSQLBuilder = {
      val (cs, vs) = columnsAndValues.unzip
      val quotedCs = cs.map {column => sqls"`$column`"}
      val quotedColumnsAndValues = quotedCs zip vs
      self.namedValues(quotedColumnsAndValues: _*)
    }
  }

  implicit class RichUpdateSQLBuilder(val self: UpdateSQLBuilder) extends AnyVal {
    def quotedSet(tuples: (SQLSyntax, ParameterBinder)*): UpdateSQLBuilder = {
      val (cs, vs) = tuples.unzip
      val quotedCs = cs.map {column => sqls"`$column`"}
      val quotedTuples = quotedCs zip vs
      self.set(sqls.csv(quotedTuples.map(each => sqls"${each._1} = ${each._2}"): _*))
    }
  }
}