List Parameter for Query

[maennchen]

The following code is not currently supported:

Adbc.Connection.query(
  connection_pid,
  """
  SELECT *
  FROM posts
  WHERE id = ANY(?1::INT[])
  """,
  [[1, 2]]
)

=>

{:error, %ArgumentError{message: "type not supported yet."}

[josevalim]

Yes, we don't support list types yet. PRs are welcome. :)

[maennchen]

I tried to take a quick stab at it, but have some issues:

• SQLite does not really support arrays except in JSON. I therefore wanted to try with Postgres
• Postgres array responses are not working: Postgres List Response #40
• Adbc seems not to support parameters with Postgres select at all

https://arrow.apache.org/adbc/0.5.1/python/recipe/postgresql.html#execute-a-statement-with-bind-parameters

Right now, the PostgreSQL driver only supports bind parameters for queries that don’t generate result sets.