Log Message:
py-sqlalchemy: updated to 1.3.1

1.3.1
orm
[orm] [bug] [ext] Fixed regression where an association proxy linked to a \ 
synonym would no longer work, both at instance level and at class level.

mssql

[mssql] [bug] A commit() is emitted after an isolation level change to SNAPSHOT, \ 
as both pyodbc and pymssql open an implicit transaction which blocks subsequent \ 
SQL from being emitted in the current transaction.

This change is also backported to: 1.2.19

[mssql] [bug] Fixed regression in SQL Server reflection due to 4393 where the \ 
removal of open-ended **kw from the Float datatype caused reflection of this \ 
type to fail due to a “scale” argument being passed.

1.3.0
orm

[orm] [feature] The Query.get() method can now accept a dictionary of attribute \ 
keys and values as a means of indicating the primary key value to load; is \ 
particularly useful for composite primary keys. Pull request courtesy Sanjana S.

[orm] [feature] A SQL expression can now be assigned to a primary key attribute \ 
for an ORM flush in the same manner as ordinary attributes as described in \ 
Embedding SQL Insert/Update Expressions into a Flush where the expression will \ 
be evaulated and then returned to the ORM using RETURNING, or in the case of \ 
pysqlite, works using the cursor.lastrowid attribute.Requires either a database \ 
that supports RETURNING (e.g. Postgresql, Oracle, SQL Server) or pysqlite.

engine

[engine] [feature] Revised the formatting for StatementError when stringified. \ 
Each error detail is broken up over multiple newlines instead of spaced out on a \ 
single line. Additionally, the SQL representation now stringifies the SQL \ 
statement rather than using repr(), so that newlines are rendered as is. Pull \ 
request courtesy Nate Clark.

See also
Changed StatementError formatting (newlines and %s)

sql
[sql] [bug] The Alias class and related subclasses CTE, Lateral and TableSample \ 
have been reworked so that it is not possible for a user to construct the \ 
objects directly. These constructs require that the standalone construction \ 
function or selectable-bound method be used to instantiate new objects.

schema
[schema] [feature] Added new parameters Table.resolve_fks and \ 
MetaData.reflect.resolve_fks which when set to False will disable the automatic \ 
reflection of related tables encountered in ForeignKey objects, which can both \ 
reduce SQL overhead for omitted tables as well as avoid tables that can’t be \ 
reflected for database-specific reasons. Two Table objects present in the same \ 
MetaData collection can still refer to each other even if the reflection of the \ 
two tables occurred separately