caseClassModels.scala

case class City(id: Long, name: String)
case class State(id: Long, abbr: String, name: String)

def citiesInPostal(postal: Long): DBIO[Seq[(City, State, Long)]] = {
  sql"""SELECT c.id, c.name, s.id, s.abbr, s.name, csp.id
       FROM location_identifier AS li,
       cities AS c,
       states AS s,
       city_state_postal AS csp
       WHERE csp.postal_code = ${postal}
       AND csp.postal_code = li.postal_code
       AND csp.city_id = c.id
       AND csp.state_id = s.id
       """.as[(City, State, Long)]
}