Ugly aggregation & count

slickcount.scala

import scala.slick.jdbc.{GetResult, StaticQuery => Q}
 
case class FooCount(n: String, c: Int)
implicit val getStatusCountResult = GetResult(r => Foo(r.nextString, r.nextInt))
 
val q = Q.queryNA[FooCount]("SELECT foo, count(foo) FROM bar GROUP BY foo")

I think you have to do it in 2 steps: http://slick.typesafe.com/doc/2.0.1/queries.html?highlight=group#aggregation

Thanks, this cleaned it up considerably. ..now trying to peak into the generated queries to see if they are efficient or barking mad..