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

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

Return ``True`` if this :class:`_engine.Result` was **hard closed** by explicitly calling the :meth:`close` method. The attribute is

Return the mapped object represented by this :class:`.InstanceState`. Returns None if the object has been garbage collected

Initialize the inter-mapper relationships of all mappers that have been constructed thus far across all :class:`_orm.registry` collections.

Apply an ``OFFSET`` to the query and return the newly resulting ``Query``. .. seealso:: :meth:`_sql.Select.offset` - v2

r"""Provide a column-level property for use with a mapping. With Declarative mappings, :func:`_orm.column_property` is used to map read-only

Apply unique filtering to the objects returned by this :class:`_engine.Result`. When this filter is applied with no arguments, the ro

Return the first element of the first result or None if no rows present. If multiple rows are returned, raises :class:`_exc.MultipleR

Begin a "nested" transaction on this Session, e.g. SAVEPOINT. The target database(s) and associated drivers must support SQL SAVEPOIN

Apply one or more GROUP BY criterion to the query and return the newly resulting :class:`_query.Query`. All existing GROUP BY setting

Construct a PostgreSQL-specific variant :class:`_postgresql.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy

r"""Implement the ``like`` operator. In a column context, produces the expression: .. sourcecode:: sql a LIKE other

When using the :paramref:`_orm.relationship.backref` parameter, provides specific parameters to be used when the new :func:`_orm.relationship`

Return a :class:`.Query` construct which will correlate the given FROM clauses to that of an enclosing :class:`.Query` or :func:`~.exp

Copy the state of a given instance into a corresponding instance within this :class:`.Session`. :meth:`.Session.merge` examines the p

r""" Specifies a DO UPDATE SET action for ON CONFLICT clause. :param index_elements: A sequence consisting of string column

Return a constant :class:`.True_` construct. E.g.: .. sourcecode:: pycon+sql >>> from sqlalchemy import true >>> print(sele

return a new :class:`_query.Query` with the specified options for the ``FOR UPDATE`` clause. The behavior of this method is i

r"""Indicate a column-based mapped attribute that by default will not load unless accessed. When using :func:`_orm.mapped_column`, the same f

Append an item to this :class:`_orm.AppenderQuery`. The given item will be persisted to the database in terms of the parent instance'

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

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

Drop all tables stored in this metadata. Conditional by default, will not attempt to drop tables not present in the target database.

Append a :class:`_schema.Constraint` to this :class:`_schema.Table`. This has the effect of the constraint being included in any

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

Return an iterator yielding result tuples corresponding to the given list of columns

Produce a conjunction of expressions joined by ``OR``. E.g.:: from sqlalchemy import or_ stmt = select(users_table).where(

Dispose of this pool. This method leaves the possibility of checked-out connections remaining open, as it only affects connections th

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

Assert a is not b, with repr messaging on failure.

Return a context manager delivering a :class:`_engine.Connection` with a :class:`.Transaction` established. E.g.:: with

Execute the given SELECT statement and return results. This method bypasses all internal statement compilation, and the statement is

Make use of a :term:`RETURNING` clause for the purpose of fetching server-side expressions and defaults, for supporting backends only.

Normalize sequence parameters for dialect that don't start with 1 by default. The default implementation does nothing

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

Produce a generic operator function. e.g.:: somecolumn.op("*")(5) produces:: somecolumn * 5 This func

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

Return a view of key/value tuples for the elements in the underlying :class:`.Row`.

r"""Return a Python property implementing a view of a target attribute which references an attribute on members of the target. The return

given cursor.lastrowid value and the parameters used for INSERT, return a "row" that represents the primary key, either by usi

sample prepare method

Given a class, return the primary :class:`_orm.Mapper` associated with the key. Raises :exc:`.UnmappedClassError` if no mapping is configured

Flush all the object changes to the database. Writes out all pending object creations, deletions and modifications to the database as

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

Return True if this :class:`_orm.Session` has begun a transaction. .. versionadded:: 1.4 .. seealso:: :attr:`_orm.Sessi

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