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

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

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

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

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

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

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

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

Assert a is b, with repr messaging on failure.

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

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

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

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

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

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

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

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

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

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"""Produce a "bound expression". The return value is an instance of :class:`.BindParameter`; this is a :class:`_expression.ColumnElement`

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

r"""Perform an UPDATE with an arbitrary WHERE clause. Updates rows matched by this query in the database. E.g.:: sess.q