[mysql] Not support where id in (?) #706

CREATE TABLE authors (
          id   bigint NOT NULL AUTO_INCREMENT,
          name varchar(100)      NOT NULL,
          PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

/* name: ListAuthorsByIDs :many */
SELECT * FROM authors
WHERE id IN (?);

// Code generated by sqlc. DO NOT EDIT.
// source: query.sql

package dao

import (
	"context"
)

const listAuthorsByIDs = `-- name: ListAuthorsByIDs :many
select id, name from authors where id in (?)
`

func (q *Queries) ListAuthorsByIDs(ctx context.Context, id int) ([]Author, error) {
	rows, err := q.db.QueryContext(ctx, listAuthorsByIDs, id)
	if err != nil {
		return nil, err
	}
	defer rows.Close()
	var items []Author
	for rows.Next() {
		var i Author
		if err := rows.Scan(&i.ID, &i.Name); err != nil {
			return nil, err
		}
		items = append(items, i)
	}
	if err := rows.Close(); err != nil {
		return nil, err
	}
	if err := rows.Err(); err != nil {
		return nil, err
	}
	return items, nil
}