Text array expression. Returns array of alternating keys and values.

r"""Produce a declarative automap base. This function produces a new base class that is a product of the :class:`.AutomapBase` class as well

Return True if the this mapper inherits from the given mapper.

Return a sequence of (key, column) tuples for all columns in this collection each consisting of a string key name and a :class:`_sql.C

target dialect supports representation of Python datetime.date() objects.

r"""Add values for bind parameters which may have been specified in filter(). Parameters may be specified using \**kwargs, or optiona

Construct a BIT. :param length: Optional, number of bits.

Create an out-of-compiler ORMCompileState object. The ORMCompileState object is normally created directly as a result of the SQLCompi

Return a "read only" form of this :class:`_sql.ColumnCollection`.

Return the bind params for this compiled object. :param params: a dict of string/object pairs whose values will overri

r"""Return a new :class:`_expression.Select` which will omit the given FROM clauses from the auto-correlation process. Callin

r"""Return information about check constraints in ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return

return string form of a sample range

Add one or more column expressions to the list of result columns to be returned. .. seealso:: :meth:`_sql.Select.add_col

Produce a type cast, i.e. ``CAST(<expression> AS <type>)``. This is a shortcut to the :func:`_expression.cast` function. .. seealso:

Annotate a portion of a primaryjoin expression with a 'foreign' annotation. See the section :ref:`relationship_custom_foreign` for a desc

Generate a declarative base class. Classes that inherit from the returned class object will be automatically mapped using declarative

r"""Indicate that for a particular entity, only the given list of column-based attribute names should be loaded; all others will be de

r"""Return a new :class:`_expression.CTE` with a SQL ``UNION`` of the original CTE against the given selectables provided as positiona

commit all attributes unconditionally. This is used after a flush() or a full load/refresh to remove all pending state from the insta

Return the 'final' SELECT statement for this :class:`.Query`. This is used by the testing suite only and is fairly inefficient. This

Return a list of table names for ``schema``. This is an internal dialect method. Applications should use :meth:`_engine.Inspector.get

Return the current root transaction in progress, if any. .. versionadded:: 1.4

Return a new :class:`_expression.Values` with the lateral flag set, so that it renders as LATERAL. .. seealso::

Produce an OVER clause against this :class:`.WithinGroup` construct. This function has the same signature as that of :meth:`.

Create filtering criterion that relates this query's primary entity to the given related instance, using established :func:`_orm.relationship(

r"""Yield only ``count`` rows at a time. The purpose of this method is when fetching very large result sets (> 10K rows), to batch re

r"""Return information about unique constraints in ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return

Return exactly one result or raise an exception. Raises :class:`_exc.NoResultFound` if the query selects no rows. Raises :class:`_exc

Indicate that the given attribute should be loaded using SELECT IN eager loading. This function is part of the :class:`_orm.Load` int

r"""Indicate that the given column-oriented attribute should be deferred, e.g. not loaded until accessed. This function is part of th

r"""Implement the ``ilike`` operator, e.g. case insensitive LIKE. In a column context, produces an expression either of the form: ..

Implement the ``IS`` operator. Normally, ``IS`` is generated automatically when comparing to a value of ``None``, which resolves to `

Return a :class:`.next_value` function element which will render the appropriate increment function for this :class:`.Sequence` within

convert the given name to lowercase if it is detected as case insensitive. This method is only used if the dialect defines re

Implement the 'concat' operator. In a column context, produces the clause ``a || b``, or uses the ``concat()`` operator on MySQL.

Rollback the current transaction in progress. If no transaction is in progress, this method is a pass-through. The method always rol

Return the schema name for the given schema item taking into account current schema translate map.

r"""Implement the ``icontains`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.contains`. Produces a LIKE express