title: Select single row based on Id in Slick
body: <p>I want to query a single row from user based on Id. I have following dummy code</p>
  
  <pre><code>case class User(
      id: Option[Int], 
      name: String
  }
  
  object Users extends Table[User]("user") {
    def id = column[Int]("id", O.PrimaryKey, O.AutoInc)
    def name = column[String]("name")
    def * = id ~ name &lt;&gt;(User, User.unapply _)
  
    def findById(userId: Int)(implicit session: Session): Option[User] = {
      val user = this.map { e =&gt; e }.where(u =&gt; u.id === userId).take(1)
      val usrList = user.list
      if (usrList.isEmpty) None
      else Some(usrList(0))
    }
  }
  </code></pre>
  
  <p>It seems to me that <code>findById</code> is a overkill to query a single column as Id is standard primary key. Does anyone knows any better ways? Please note that I am using Play! 2.1.0</p>