SELECT MIN "column name invalid"

[leshow]

Has anyone else had this issue? I'm trying a query with the form SELECT MIN(column) FROM table and sqlx is telling me "column name min(column) is invalid"

How do you get sqlx to recognize the min or max functions?

[abonander]

If this is with the macros, you need to give the column a name that is a valid Rust identifier. The default name for the column here is literally min(column) so that's not gonna work.

Try SELECT MIN(column) AS column_min FROM table