Appends SQLSyntax directly.
Appends SQLSyntax directly. e.g. select.from(User as u).where.eq(u.id, 123).append(sqls"order by ${u.id} desc")
Converts SQLBuilder to sub-query part sqls.
Converts SQLBuilder to sub-query part sqls. e.g. val x = SubQuery.syntax("x").include(u, g) withSQL { select.from(select.from(User as u).leftJoin(Group as g).on(u.groupId, g.id).where.eq(u.groupId, 234).as(x)) }
Maps SQLBuilder as follows.
Maps SQLBuilder as follows. e.g. select.from(User as u).where.eq(u.id, 123).map { sql => if(name.isDefined) sql.and.eq(u.name, name) else sql }
Appends a round bracket in where clause.
Appends a round bracket in where clause. e.g. select.from(User as u).where.withRoundBracket { _.eq(u.id, 123).and.eq(u.groupId, 234) }.or.eq(u.groupId, 345)
(Since version 1.6.2) use between(column: SQLSyntax, a: Any, b: Any) instead
Appends conditions with delimiter.
Appends conditions with delimiter. This API is depreacted. Use #where/#and/#or(Option[SQLSyntax]) instead.
.where .dynamicAndConditions( id.map(i => sqls.eq(u.id, i)), Some(sqls.isNotNull(u.name)) )
(Since version 1.6.5) use #where(sqls.toAndConditionOpt(conditions)), #and(sqls.toAndConditionOpt(conditions)), #or(sqls.toAndConditionOpt(conditions)) instead
(Since version 1.6.5) use #where(sqls.toOrConditionOpt(conditions)), #and(sqls.toOrConditionOpt(conditions)), #or(sqls.toOrConditionOpt(conditions)) instead