scalikejdbc-interpolation/scalikejdbc/QueryDSLFeature/QueryDSL/select

select

scalikejdbc.QueryDSLFeature.QueryDSL.select

object select

Query Interface for select query.

 implicit val session = AutoSession
 val u = User.syntax("u")
 val user = withSQL { select.from(User).where.eq.(u.id, 123) }.map(User(u.resultName)).single.apply()
 val userIdAndName = withSQL {
   select(u.result.id, u.result.name).from(User).where.eq.(u.id, 123)
 }.map(User(u.resultName)).single.apply()