Select Values in Mysql

Discussed in https://github.com/sqlalchemy/sqlalchemy/discussions/10309

^{Originally posted by RasulGafarov September 4, 2023}
The following code:

my_select = select(
            Values(
                sqlalchemy.column("column_1", String),
                sqlalchemy.column("column_1", String),
                name="temp_1", literal_binds=True
            ).data([("a", "2"), ("b", "3")]))

generates sql:

SELECT temp_1.column_1, temp_1.column_1 AS column_1_1 
FROM (VALUES ('a', '2'), ('b', '3')) AS temp_1 (column_1, column_1)

this code causes an error because mysql (8.0.33) requires the following syntax:

SELECT temp_1.column_1, temp_1.column_1 AS column_1_1
FROM (VALUES ROW('a', '2'), ROW('b', '3')) AS temp_1 (column_1, column_1)

https://dev.mysql.com/doc/refman/8.0/en/values.html

how to fix this error? Thank you in advance

Start from the Values and select entry points that produce the shown SQL, then compare the MySQL 8.0.33 VALUES syntax in the linked MySQL documentation. Reproduce the generated query against MySQL and verify that the resulting SQL uses the required ROW form and executes successfully.