Revision history [back]

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.