[Sqlalchemy-tickets] Issue #3634: sqlite right-nested joins now function (zzzeek/sqlalchemy)

[Mike B. <iss...@bi...>]

New issue 3634: sqlite right-nested joins now function
https://bitbucket.org/zzzeek/sqlalchemy/issues/3634/sqlite-right-nested-joins-now-function

Mike Bayer:

the test given in http://docs.sqlalchemy.org/en/rel_1_0/changelog/migration_09.html#many-join-and-left-outer-join-expressions-will-no-longer-be-wrapped-in-select-from-as-anon-1 for SQlite now passes.  we need to turn off join rewriting for SQLite and basically mothball the whole feature.

sitll working to bisect which SQLite version this is repaired within.

also see #3633.

would want to turn this off by default in 1.1 but for 1.0 perhaps use a flag as this is a big change.