What causes an error in SQLAlchemy and MariaDB when using a column named 'row_number'?

edit

The error occurs because 'row_number' is a reserved keyword in MariaDB, and therefore cannot be used as a column name. SQLAlchemy generates SQL code that includes the column name without quoting it, which leads to a syntax error when MariaDB encounters the reserved keyword. To avoid this error, you should rename the column to something else.