Clear all objects from this MetaData.

Construct a sqlite-specific variant :class:`_sqlite.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy.dialect

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

Invoke the given synchronous (i.e. not async) callable, passing a synchronous-style :class:`_orm.Session` as the first argument.

Add a table hint for a single table to this INSERT/UPDATE/DELETE statement. .. note:: :meth:`.UpdateBase.with_hint` current

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

Create a ``UNION`` statement used by a polymorphic mapper. See :ref:`concrete_inheritance` for an example of how this is used. :param t

update the :paramref:`_orm.registry.type_annotation_map` with new values.

legacy adapter function for functions that were previously using assert_raises with SAWarning or similar. has some workarounds to accommodate

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

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

Return information about foreign_keys in ``table_name``. Given a :class:`_engine.Connection`, a string ``table_name``, and an optiona

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

Return a context that optimizes for multiple operations on a single transaction. This essentially allows connect()/close() to be call

Return ``True`` if this :class:`.ReturnsRows` is 'derived' from the given :class:`.FromClause`. Since these are DMLs, we dont want su

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

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

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

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

Specifies a DO NOTHING action for ON CONFLICT clause. :param index_elements: A sequence consisting of string column names,

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

Indicate an attribute should load using its predefined loader style. The behavior of this loading option is to not change the current

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

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

Return a list of ENUM objects. Each member is a dictionary containing these fields: * name - name of the enum * sche

Construct a MySQL/MariaDB-specific variant :class:`_mysql.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy.d

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

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

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

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

Subclasses should call this method whenever change events occur.

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

Return exactly one scalar result or raise an exception. This is equivalent to calling :meth:`_engine.Result.scalars` and then :meth:`

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

Apply a :class:`.SyntaxExtension` to a known extension point. Should be used only internally by :class:`.SyntaxExtension`. E.g.::

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

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

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

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

Return a string describing an instance via its InstanceState.

r"""Associate a SQL expression with a particular type, without rendering ``CAST``. E.g.:: from sqlalchemy import type_coerce

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