PossiblyInfixAction

In some cases the action that goes inside the batch needs an infix. For example, for SQL server to be able to do batch inserts of rows with IDs you need to do something like: {{ liftQuery(products).foreach(p => sql"SET IDENTITY_INSERT Product ON; ${query[Product].insertValue(p)}".as[Insert[Int]]) }} In order to yield something like this: {{ SET IDENTITY_INSERT Product ON; INSERT INTO Product (id,description,sku) VALUES (?, ?, ?) }} Otherwise SQLServer will not let you insert the row because IDENTITY_INSERT will be off.