implicitval 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()
Query Interface for select query.
}