Kyle Gray

@skariel Updated your example to be self-contained. I can confirm this is this still an issue.

@tv42 Can you provide a complete example for this issue? Since this involves type overrides, can you include a sqlc configuration file, database schema, and example queries.

@tv42 whoops, sorry about that. Thanks for writing up the full example.

Here's some related discussion from the go-sql-driver repository: * https://github.com/go-sql-driver/mysql/issues/107 * https://github.com/go-sql-driver/mysql/issues/176

The [MEMBER OF](https://dev.mysql.com/doc/refman/8.0/en/json-search-functions.html#operator_member-of) syntax may offer a solution. The problem is that you need to encode the slice as JSON before passing it into the query. ```sql CREATE TABLE pkg...

Okay, here's my current idea. We add a second type parameter to `sqlc.arg`. That parameter, if passed, will compile to a cast statement. We can support the ARRAY type syntax...

Reproduced [on the playground](https://play.sqlc.dev/p/27839e83281016a67460edc41dddf281b20f515ef4bc0c2bb825ef9e6a955afb)

MySQL is fully supported in sqlc. Many of the queries in your bug report aren't valid, hence the compilation failures. First, the shorthand CAST operator (`::`) isn't supported by MySQL....

Similar bug to https://github.com/kyleconroy/sqlc/issues/1453

Confirmed that this now works :) https://play.sqlc.dev/p/0ac3182108229aa90ff756658d45e2fc43c865517fa63f42c4339cb2b462a11e