use member of replace where in get syntax error

[silver-brother]

Version

1.16.0

What happened?

In mysql, I want to use member of syntax instead of where in syntax, but I encounter a compile error

Relevant log output

syntax error near "member of (?);"

Database schema

CREATE TABLE `song` (
  `id` varchar(64) NOT NULL DEFAULT '',
  `create_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) COMMENT '创建时间',
  `update_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3) ON UPDATE CURRENT_TIMESTAMP(3) COMMENT '修改时间',
  `name` varchar(256) NOT NULL DEFAULT '' COMMENT ' 歌曲名称 。 ',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

SQL queries

-- name: ListSongByIDS :many
SELECT *
FROM song
where id member of (?);

Configuration

version: "2"
sql:
  - schema: "./schema"
    queries: "./queries"
    engine: "mysql"
    gen:
      go:
        package: "model"
        out: "model"

Playground URL

https://play.sqlc.dev/p/8f37ba937f2e300b40fca209d3aaa88abe441855fb8c3fd52dd0d6b5df25196a

What operating system are you using?

macOS

What database engines are you using?

MySQL

What type of code are you generating?

Go

[bas-ie]

I think this is not currently supported. Note #695.

[kyleconroy]

@richchurcher is correct, this is currently not supported. Hopefully sometime in the future!