Args in mysql ORDER BY not respected

[seanlaff]

Version

1.25.0

What happened?

The postgres generator supports variables in the ORDER BY, but mysql does not.

SELECT * FROM authors
ORDER BY MOD(id, sqlc.arg(foo));

const listAuthors = `-- name: ListAuthors :many
SELECT id, name FROM authors
ORDER BY MOD(id, sqlc.arg(foo))

Relevant log output

No response

Database schema

No response

SQL queries

No response

Configuration

No response

Playground URL

https://play.sqlc.dev/p/a2272d7f92f2e1a2a6c122dd3e38fa8ec9625a107fc55b93a45c6db7558d85bc

What operating system are you using?

macOS

What database engines are you using?

MySQL

What type of code are you generating?

Go