Slick.scala

case class Address(id:Option[Long], 
                   street1: String, 
                   street2: Option[String] = None, 
                   city: String, 
                   state: String, 
                   zipCode: String) extends DBObject
                   
class Addresses(tag: Tag) extends IndexedTable[Address](tag, "addresses") {
  def street1 = column[String]("street1")
  def street2 = column[Option[String]]("street2")
  def city = column[String]("city")
  def zipCode = column[String]("zip_code", O.Length(10,true))
  def state = column[String]("state")

  def * = (id ?, street1, street2, city, state, zipCode) <> (Address tupled, Address unapply)
}

Find Query:

someTable.filter(_.id === someId).list.headOption

squeryl.scala

case class Address( override val id: Option[Long],
                    @Column("agency_id") agencyId: Option[Long],
                    state: String,
                    city: String,
                    @Column("cip_code") zipCode: String,
                    address1: String,
                    address2: String,
                   ) extends IndexedModel[Long] with TimeStamps

Find Query:

from(someTable)(t => select(t) where(_.id === someId)).headOption