scalikejdbc and MySQL subquery WHERE IN (SELECT statement)

Question

It looks like scalikejdbc doesn't support MySQL's WHERE IN (SELECT statement) queries, as IN requires a sequence of items as a parameter, it doesn't accept a query.

Any ideas for making it work? Thank you!

Answer 1

Turns out sqls.in() supports SQLSyntax as a second parameter.