return string form of a sample range

Produce a SQL statement that is cached as a lambda. The Python code object within the lambda is scanned for both Python literals that will be

implement the ``NOT IN`` operator. This is equivalent to using negation with :meth:`.ColumnOperators.in_`, i.e. ``~x.in_(y)``.

target database can render OFFSET, or an equivalent, in a SELECT.

r"""Add one or more expressions following the statement keyword, i.e. SELECT, INSERT, UPDATE, or DELETE. Generative. This is used to

r"""Return a new :class:`_expression.CTE` with a SQL ``UNION`` of the original CTE against the given selectables provided as positiona

Create filtering criterion that relates this query's primary entity to the given related instance, using established :func:`_orm.relationship(

r"""Indicate that the given attribute should be eagerly loaded from columns stated manually in the query. This function is part of th

Prepare a quoted column name.

r"""Return information about check constraints in ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return

r"""Return the "comment" for the table identified by ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return

Make this :class:`_expression.Insert` construct "inline" . When set, no attempt will be made to retrieve the SQL-generated default va

r""" Specifies the ON DUPLICATE KEY UPDATE clause. :param \**kw: Column keys linked to UPDATE values. The values may be an

Return a dialect-specific bind processor for this type.

Produce a :func:`_expression.collate` clause against the parent object, given the collation string. .. seealso:: :func:`

Return a :class:`.False_` construct. E.g.: .. sourcecode:: pycon+sql >>> from sqlalchemy import false >>> print(select(t.c.

r"""Return information about unique constraints in ``table_name``. Given a string ``table_name`` and an optional string ``schema``, return

r"""Implement the ``ilike`` operator, e.g. case insensitive LIKE. In a column context, produces an expression either of the form: ..

Implement the ``IS`` operator. Normally, ``IS`` is generated automatically when comparing to a value of ``None``, which resolves to `

r"""Return ``True`` if the given instance has locally modified attributes. This method retrieves the history for each instrumented

Register class instrumentation. Returns the existing or newly created class manager.

Remove the given Table object from this MetaData.

utility method to create ratios of two implementation

Return the 'final' SELECT statement for this :class:`.Query`. This is used by the testing suite only and is fairly inefficient. This

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

Apply "render derived" to this :class:`_sql.TableValuedAlias`. This has the effect of the individual column names listed out after th

Compare two range bounds. Return -1, 0 or 1 respectively when `value1` is less than, equal to or greater than `value2`. When

Extend a numeric-type declaration with MySQL specific extensions.

Execute a statement and assert that rows returned equal expected.

r"""Apply a HAVING criterion to the query and return the newly resulting :class:`_query.Query`. :meth:`_query.Query.having` is used i

r"""Implement the ``icontains`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.contains`. Produces a LIKE express

r"""Update the default execution_options dictionary of this :class:`_engine.Engine`. The given keys/values in \**opt are added to the

Produce a WITHIN GROUP (ORDER BY expr) clause against this function.

python 3.14 has made ForwardRefs not really comparable or reliably hashable. As we need to compare types here, including structures like

r"""Return a :class:`_engine.Connection` object corresponding to this :class:`.Session` object's transactional state. Either the :cla

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

Retrieve a value from the given object. If a callable is assembled on this object's attribute, and passive is False, the callable will

return an optional cache key. The cache key is a tuple which can contain any series of objects that are hashable and also identifies

r"""A placeholder that may be used in compiled INSERT or UPDATE expressions to refer to the SQL expression or value being applied to another colum

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

Render this :class:`_engine.URL` object as a string. This method is used when the ``__str__()`` or ``__repr__()`` methods are used.

Return the schema name for the given schema item taking into account current schema translate map.

r"""Specify a fixed VALUES clause for an INSERT statement, or the SET clause for an UPDATE. Note that the :class:`_expression.Insert`

Create a copy of this ``Column``, uninitialized. This is used in :meth:`_schema.Table.to_metadata` and by the ORM.