SQLSyntax - sqls

 

http://scalikejdbc.org/documentation/sql-interpolation.html 의 SQLSyntax

 

val ordering = if (isDesc) sqls"desc" else sqls"asc"
val members = sql"select id, name from members order by id ${ordering} limit 10"
  .map(rs => Member(rs)).list.apply()

 

이는 아래와 같이 변환된다.

select id , name from members order by id desc limit 10