sqlite: `WHERE ... IN (?)` generates query with no parameters

trevorstarick commented 2 years ago

Version

1.15.0

What happened?

When generating a query using a WHERE ... IN (?) statement, I expected to get a function out that looked similar to func (q *Queries) Foo(ctx context.Context, in []interface{}) ([]string, error) but the in []interface{} parameter isn't included.

Current workaround is to export the query and then have sqlx handle it via it's support for in queries.

Relevant log output

No response

Database schema

CREATE TABLE foo (
    hash TEXT NOT NULL PRIMARY KEY
)

SQL queries

-- name: Foo :many
SELECT * FROM foo WHERE hash IN (?) LIMIT 50;

Configuration

version: 2
sql:
    - engine: "sqlite"
      schema: "schema.sql"
      queries: "queries.sql"
      gen:
        go:
            package: "example"
            out: "example"
            emit_db_tags: true
            emit_prepared_queries: true
            emit_exact_table_names: true
            emit_empty_slices: true
            emit_exported_queries: true
            emit_json_tags: true