I'm about 70% done with an enterprise integration using Play 2, Squeryl, Akka, SOAP, JMS integrating two different major SaaS providers in conjunction with our internal ESB. Thanks for posting this, I've referenced it several times.

One quick thing to note with regards to your case class approach and Squeryl: embedding the id value within the case class itself, as opposed to placing it on the constructor, negates case class copy. That is to say, now you can't simply update the model instance by copying it, b/c the id will always remain 0. Perhaps I'm missing something, or wondered if this was intentional?