How to pass an indefinite amount of parameters to an sql query?

[cheprus]

Hi there,
Is there a right way to pass a list of parameters to an sql query?
select * from table where id in ( 'a', 'list', 'of', 'ids' )

Now I prepare a variable as String, but it looks unsecure.

val query = """ select * from table where id in ( ${idList} ) """.trimMargin()
l = kotliquery.queryOf(sqlMI).map(toMyObject).asList
session.run(l)

[seratch]

This library does not support any builders for safely constructing an in-clause. You can go with the way that you mentioned. I would suggest accepting only ID values, not arbitrary values passed by the method caller.