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)) }
Appends conditions with delimiter.
Appends conditions with delimiter.
.where .dynamicAndConditions( id.map(i => sqls.eq(u.id, i)), Some(sqls.isNotNull(u.name)) )
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)