Type-hinting for MySQL?

[alecbz]

Is there a way to get the "type hinting" in https://github.com/kyleconroy/sqlc/blob/master/docs/named_parameters.md (e.g., sqlc.arg(set_name)::bool) to work for MySQL?

I'm trying to get types for a query like:

SELECT * FROM things
WHERE x = sqlc.arg(x)
  AND y = sqlc.arg(y)
  AND ABS(DATEDIFF(created_at, sqlc.arg(created_at))) < 15;

but CreatedAt in the result struct is an interface{} (and sqlc outputs " unknown MySQL type: any")

Trying to do a MySQL-style CAST(sqlc.arg(created_at) AS DATETIME) results in sqlc getting confused and just omitting the CreatedAt arg altogether.

Is this supposed to work right now, or is it a known issue that more work needs to be done to support this?

[kyleconroy]

Is this supposed to work right now

Nope!

or is it a known issue that more work needs to be done to support this?

Most certainly a known issue. The sqlc.arg(set_name)::bool syntax is PostgreSQL syntactic sugar for CAST ... AS. I've opened #687 to track implementation.

I'd also like to point out #655, which would also fix your issue. Since the DATEDIFF function takes two arguments of known types, sqlc will pick the correct type automatically. The issue is that I haven't generated the functions definitions yet. Soon!