Denote an attribute name as a synonym to a mapped property, in that the attribute will mirror the value and expression behavior of another att

r"""Apply a ``DISTINCT`` to the query and return the newly resulting ``Query``. .. note:: The ORM-level :meth:`.distinc

sample prepare method

Append a :class:`_schema.Column` to this :class:`_schema.Table`. The "key" of the newly added :class:`_schema.Column`, i.e. the value

For internal dialect use, check the existence of a particular table or view in the database. Given a :class:`_engine.Connection` obje

Close out the transactional resources and ORM objects used by this :class:`_orm.Session`. This expunges all ORM objects associated wi

Remove the `instance` from this ``Session``. This will free all internal references to the instance. Cascading will be applied accor

r"""Return a new selectable with the given FETCH FIRST criterion applied. This is a numeric value which usually renders as ``FETCH {F

Applies a SQL syntax extension to this statement. .. seealso:: :ref:`examples_syntax_extensions` :func:`_mysql.limi

r"""Produce a copy of this type object that will utilize the given type when applied to the dialect of the given name. e.g.::

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

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

Return a new :class:`_expression.Insert` construct which represents an ``INSERT...FROM SELECT`` statement. e.g.:: sel =

r"""Construct a new :class:`_expression.TString` clause, representing a SQL template string using Python 3.14+ t-strings. .. versionadded:: 2

utility method used for unit tests only.

Configure all as-yet unconfigured mappers in this :class:`_orm.registry`. The configure step is used to reconcile and initialize the

Return a copy of this :class:`_schema.Table` associated with a different :class:`_schema.MetaData`. E.g.:: m1 = MetaData

r"""Construct :class:`_expression.Delete` object. E.g.:: from sqlalchemy import delete stmt = delete(user_table).where(user_tab

Add additional WHERE criteria to the load for all occurrences of a particular entity. .. versionadded:: 1.4 The :func:`_orm.with_loader_

r"""Produce a ``CASE`` expression. The ``CASE`` construct in SQL is a conditional object that acts somewhat analogously to an "if/then" const

r"""Create a SQL JOIN against this :class:`_expression.Select` object's criterion and apply generatively, returning the newly resultin

Generate an :func:`_expression.update` construct against this :class:`_expression.TableClause`. E.g.:: table.update().wh

r"""Implement the 'endswith' operator. Produces a LIKE expression that tests against a match for the end of a string value:

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

Conditionally quote an identifier. The identifier is quoted if it is a reserved word, contains quote-necessary characters, or is an i

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

Issue a ``DROP`` statement for this :class:`_schema.Table`, using the given :class:`.Connection` or :class:`.Engine` for connectivity.

Apply a mappings filter to returned rows, returning an instance of :class:`_engine.MappingResult`. When this filter is applied, fetch

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

return Range form of the same range

Return information about indexes in ``table_name``. Given a :class:`_engine.Connection`, a string ``table_name`` and an optional stri

r"""Add one or more :class:`_sql.CTE` constructs to this statement. This method will associate the given :class:`_sql.CTE` constructs with

Return a dialect-specific implementation for this :class:`.TypeEngine`.

Expires all persistent instances within this Session. When any attributes on a persistent instance is next accessed, a query will be

return a MapperProperty associated with the given key.

Produce a :func:`_expression.between` clause against the parent object, given the lower and upper range.

Produce a UNION ALL of this Query against one or more queries. Works the same way as :meth:`~sqlalchemy.orm.query.Query.union`. See t

Construct a new bakery. :return: an instance of :class:`.Bakery`

Close this Session, using connection invalidation. This is a variant of :meth:`.Session.close` that will additionally ensure that the

Return a :class:`.Tuple`. Main usage is to produce a composite IN construct using :meth:`.ColumnOperators.in_` :: from sqlalchemy im

Produce a UNION of this Query against one or more queries. e.g.:: q1 = sess.query(SomeClass).filter(SomeClass.foo == "bar")

Return a collection of added + unchanged + deleted.

Add an individual MapperProperty to this mapper. If the mapper has not been configured yet, just adds the property to the initial pro

r"""Return a :class:`_sql.TableValuedAlias` representation of this :class:`_functions.FunctionElement` with table-valued expressions added.

r"""Construct a :class:`_expression.Values` construct representing the SQL ``VALUES`` clause. The column expressions and the actual data for

Remove all mappers from all classes. .. versionchanged:: 1.4 This function now locates all :class:`_orm.registry` objects and calls upon

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

Prepare a quoted table and schema name.

Build DB-API compatible connection arguments. Given a :class:`.URL` object, returns a tuple consisting of a ``(*args, **kwargs)`` sui

Returns a copy of the BitString with both leading and trailing characters removed. If omitted or None, ``'char'`` defaults to ``"0"``:

Not supported for TString constructs. TString constructs do not support .bindparams(). Bind parameters are automatically created from