delta/python-packages/sqlalchemy.git/lib/sqlalchemy/sql/expression.py, branch fix_mariadb102_default

Recognize brackets, quoted_name in SQL Server schema

2017-04-04T17:45:06+00:00

The SQL Server dialect now allows for a database and/or owner name
with a dot inside of it, using brackets explicitly in the string around
the owner and optionally the database name as well.  In addition,
sending the :class:`.quoted_name` construct for the schema name will
not split on the dot and will deliver the full string as the "owner".
:class:`.quoted_name` is also now available from the ``sqlalchemy.sql``
import space.

Change-Id: I77491d63ce47638bd23787d903ccde2f35a9d43d
Fixes: #2626

update for 2017 copyright

2017-01-04T17:39:24+00:00

Change-Id: I4e8c2aa8fe817bb2af8707410fa0201f938781de

Correct any_, all_ spelling

2016-12-28T21:14:31+00:00

- Fixed 1.1 regression where "import *" would not work for
sqlalchemy.sql.expression, due to mis-spelled "any_" and "all_"
functions.

Change-Id: I25d1cd34c9239dbdcdb1889c5cda2474557e1418
Fixes: #3878

Add TABLESAMPLE clause support.

2016-06-15T18:42:08+00:00

The TABLESAMPLE clause allows randomly selecting an approximate percentage
of rows from a table. At least DB2, Microsoft SQL Server and recent
Postgresql support this standard clause.

Fixes: #3718
Change-Id: I3fb8b9223e12a57100df30876b461884c58d72fa
Pull-request: https://github.com/zzzeek/sqlalchemy/pull/277

- Added :meth:`.Select.lateral` and related constructs to allow

2016-03-29T21:56:02+00:00

for the SQL standard LATERAL keyword, currently only supported
by Postgresql.  fixes #2857

- CTE functionality has been expanded to support all DML, allowing

2016-02-11T17:27:28+00:00

INSERT, UPDATE, and DELETE statements to both specify their own
WITH clause, as well as for these statements themselves to be
CTE expressions when they include a RETURNING clause.
fixes #2551

- happy new year

2016-01-29T16:20:22+00:00

- The :func:`.type_coerce` construct is now a fully fledged Core

2015-09-16T22:46:53+00:00

expression element which is late-evaluated at compile time.  Previously,
the function was only a conversion function which would handle different
expression inputs by returning either a :class:`.Label` of a column-oriented
expression or a copy of a given :class:`.BindParameter` object,
which in particular prevented the operation from being logically
maintained when an ORM-level expression transformation would convert
a column to a bound parameter (e.g. for lazy loading).
fixes #3531

- Added support for "set-aggregate" functions of the form

2015-08-26T21:19:27+00:00

`` WITHIN GROUP (ORDER BY )``, using the
method :class:`.FunctionElement.within_group`.  A series of common
set-aggregate functions with return types derived from the set have
been added. This includes functions like :class:`.percentile_cont`,
:class:`.dense_rank` and others.
fixes #1370
- make sure we use func.name for all _literal_as_binds in functions.py
so we get consistent naming behavior for parameters.

- build out a new base type for Array, as well as new any/all operators

2015-08-25T22:24:46+00:00

- any/all work for Array as well as subqueries, accepted by MySQL
- Postgresql ARRAY now subclasses Array
- fixes #3516