Just a quick warning to others: I noticed this warning when running a maintenance script that used the Windowed Range Query example:
/sqlalchemy/sql/elements.py:3736: SAWarning: Textual SQL expression 'rownum % 100=1' should be explicitly declared as text('rownum % 100=1') (this warning may be suppressed after 10 occurrences) The fix was simple, and I've updated the wiki: - q = q.filter("rownum %% %d=1" % windowsize) <https://bitbucket.org/zzzeek/sqlalchemy/wiki/commits/f165e0cb07038d9fd07abc72328accf0fb5d8b94#LUsageRecipes/WindowedRangeQuery.mdT42> + q = q.filter(sqlalchemy.text("rownum %% %d=1" % windowsize)) https://bitbucket.org/zzzeek/sqlalchemy/wiki/history/UsageRecipes/WindowedRangeQuery -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.