Datatype mismatch due to JSON encoding of lists in IN statements

[ocean]

There's a minor topic, the new list-to-JSON encoding converts all lists via Jason.encode including for IN statements, so I'm getting a datatype mismatch:
[error] GenServer {Oban.Registry, {Oban, Oban.Stager}} terminating
** (EctoLibSql.Error) SQLite failure: datatype mismatch
(ecto_sql 3.13.4) lib/ecto/adapters/sql.ex:1113: Ecto.Adapters.SQL.raise_sql_call_error/1

e.g.

WHERE j.state IN (?, ?) with params ["scheduled", "retryable"]

becomes

WHERE j.state IN ('[\"scheduled\",\"retryable\"]')

Originally posted by @nadilas in #57 (comment)

[ocean]

Excellent, thanks for the bug report @nadilas, I'll fix that soon too.

This is my first Elixir library, I'm using it in a side project which is still in development, because I wanted to try out Turso/libSQL. Because I haven't pushed the usage of it much yet, and it's only new, there isn't much "real world" usage, so your feedback is very useful to find all the actual use cases that haven't been caught by tests yet.

[ocean]

Thanks for your patience @nadilas - please try again with the latest release, 0.8.8, I've focused on bug fixes and have fixed the "IN" clause conversion issue as far as I can tell from testing.