Assert a == b, with repr messaging on failure.

Provide a relationship between two mapped classes. This corresponds to a parent-child or associative table relationship. The constructed clas

r"""Map a class imperatively. In this form of mapping, the class is not scanned for any mapping information. Instead, all mapping co

A synonym for :meth:`.Query.filter`. .. versionadded:: 1.4 .. seealso:: :meth:`_sql.Select.where` - v2 equivalent metho

Return the results represented by this :class:`_query.Query` as a list. This results in an execution of the underlying SQL statement.

r"""Create a SQL JOIN against this :class:`_query.Query` object's criterion and apply generatively, returning the newly resulting

Apply one or more ORDER BY criteria to the query and return the newly resulting :class:`_query.Query`. e.g.:: q = sessio

Produce a :class:`.ColumnClause` object. The :class:`.ColumnClause` is a lightweight analogue to the :class:`_schema.Column` class. The :fun

r"""Apply the given filtering criterion to a copy of this :class:`_query.Query`, using SQL expressions. e.g.:: session.q

Flush pending changes and commit the current transaction. When the COMMIT operation is complete, all objects are fully :term:`expired

r"""Create a :class:`_expression.Select` from this :class:`_expression.Join`. E.g.:: stmt = table_a.join(table_b, table_

Return a new :class:`_query.Query` object, applying the given list of mapper options. Most supplied options regard changing h

Assert a is b, with repr messaging on failure.

Return the first result of this ``Query`` or None if the result doesn't contain any row. first() applies a limit of one within the ge

Create all tables stored in this metadata. Conditional by default, will not attempt to recreate tables already present in the target

r"""declare a new ORM-mapped :class:`_schema.Column` construct for use within :ref:`Declarative Table <orm_declarative_table>` configuration.

Produce a new :class:`_expression.TableClause`. The object returned is an instance of :class:`_expression.TableClause`, which represents

Return an :class:`_expression.Alias` of this :class:`_expression.CTE`. This method is a CTE-specific specialization of the :m

r"""Set the FROM clause of this :class:`.Query` explicitly. :meth:`.Query.select_from` is often used in conjunction with :meth:`.Quer

Return the full SELECT statement represented by this :class:`_query.Query`, embedded within an :class:`_expression.Alias`. Ea

Provide a copy of this :class:`.Bundle` passing a new label.

Add the given collection of instances to this :class:`_orm.Session`. See the documentation for :meth:`_orm.Session.add` for a general

r"""Produce a ``CAST`` expression. :func:`.cast` returns an instance of :class:`.Cast`. E.g.:: from sqlalchemy import cast, Numeric

Implement the ``in`` operator. In a column context, produces the clause ``column IN <other>``. The given parameter ``other`` may be:

r"""Construct a new :class:`_expression.TextClause` clause, representing a textual SQL string directly. E.g.:: from sqlalchemy i

Remove all object instances from this ``Session``. This is equivalent to calling ``expunge(obj)`` on all objects in this ``Session``.

r"""Executes a string SQL statement on the DBAPI cursor directly, without any SQL compilation steps. This can be used to pass any str

r"""Perform a DELETE with an arbitrary WHERE clause. Deletes rows matched by this query from the database. E.g.:: sess.

Produce a string-compiled form of this :class:`.TypeEngine`. When called with no arguments, uses a "default" dialect to produce a str

r"""Apply the given filtering criterion to a copy of this :class:`_query.Query`, using keyword expressions. e.g.:: sessi

r"""Produce a "bound expression". The return value is an instance of :class:`.BindParameter`; this is a :class:`_expression.ColumnElement`

Apply column labels to the return value of Query.statement. Indicates that this Query's `statement` accessor should return a SELECT s

Place an object into this :class:`_orm.Session`. Objects that are in the :term:`transient` state when passed to the :meth:`_orm.Sessi

Apply a ``LIMIT`` to the query and return the newly resulting ``Query``. .. seealso:: :meth:`_sql.Select.limit` - v2 equ

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

Return an instance based on the given primary key identifier, or ``None`` if not found. E.g.:: my_user = session.query(U

r"""Return the full SELECT statement represented by this :class:`_query.Query` represented as a common table expression (CTE). Parame

r"""Produce a :class:`.ColumnClause` object that has the :paramref:`_expression.column.is_literal` flag set to True. :func:`_expression.liter

r"""Produce a conjunction of expressions joined by ``AND``. E.g.:: from sqlalchemy import and_ stmt = select(users_table).where

Expire the attributes on an instance. Marks the attributes of an instance as out of date. When an expired attribute is next accessed,

Implements a database-specific 'match' operator. :meth:`_sql.ColumnOperators.match` attempts to resolve to a MATCH-like function or o

r"""Implement the ``startswith`` operator. Produces a LIKE expression that tests against a match for the start of a string value:

Create a left outer join against this ``Query`` object's criterion and apply generatively, returning the newly resulting ``Query``. U

Produce an :class:`.AliasedClass` construct which specifies columns for descendant mappers of the given base. Using this method will ensure t

Context manager which expects one or more warnings. With no arguments, squelches all SAWarning emitted via sqlalchemy.util.warn and sqlalchem

A schema.Table wrapper/hook for dialect-specific tweaks.

r"""Construct a base class for declarative class definitions. The new base class will be given a metaclass that produces appropriate :class:`

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