Is this possible to apply function to each item of sqlc.slice? · sqlc-dev/sqlc · Discussion #3203

umed
Feb 15, 2024

Hi guys,

So, I have mysql table with key column of uuid type (binary[16]). I would like to select multiple values at once using IN and sqlc.slice:

-- name: QueryName :many
SELECT *
FROM mytable
WHERE id in (sqlc.slice(ids));

But I need to pass each item of slice to UUID_TO_BIN, so above query would map to something like this:

-- name: QueryName :many
SELECT *
FROM mytable
WHERE id in (UUID_TO_BIN(id1), UUID_TO_BIN(id2), ...);

Is there any way to achieve this?