query param use array: SELECT...in ( array)

[kekxv]

How to do it:

SELECT * FROM users WHERE username in (:usernames);

:usernames is array

[samjayhk]

Have you found the solution?

[samjayhk]

Dear @lganzzzo

Thanks for your great work!

I'm encountering an issue with the IN() command in oatpp-SQLite. It seems that currently, there is no way to insert string parameters that are not supported by the scope (such as "12,14,15" for IN()), whether using the IN() command or simply using the OR command. However, if I hardcode the QUERY command with IN() or OR, it works as expected.

Is there a workaround or a recommended approach to handle this issue?

Thank.