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

r"""Implement the ``istartswith`` operator, e.g. case insensitive version of :meth:`.ColumnOperators.startswith`. Produces a LIKE exp

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

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

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

Return a string describing an instance via its InstanceState.

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

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

Indicate an attribute should load using its predefined loader style. The behavior of this loading option is to not change the current

Prepare a quoted column name.

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

Construct a MySQL/MariaDB-specific variant :class:`_mysql.Insert` construct. .. container:: inherited_member The :func:`sqlalchemy.d

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

Remove the given Table object from this MetaData.

r"""Associate a SQL expression with a particular type, without rendering ``CAST``. E.g.:: from sqlalchemy import type_coerce

r"""Called before CREATE statements are emitted. :param target: the :class:`.SchemaObject`, such as a :class:`_schema.MetaData` or :

Perform a bulk insert of the given list of mapping dictionaries. .. legacy:: This method is a legacy feature as of the 2.0 serie

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

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

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

Return a dialect-specific bind processor for this type.

Produce an ANY expression. For dialects such as that of PostgreSQL, this operator applies to usage of the :class:`_types.ARRAY` datatype, for

Perform a bulk save of the given list of objects. .. legacy:: This method is a legacy feature as of the 2.0 series of

reset the cache for this :class:`.Inspector`. Inspection methods that have data cached will emit SQL queries when next called to get

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

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

Create a new async engine instance. Arguments passed to :func:`_asyncio.create_async_engine` are mostly identical to those passed to the :fun

Return information about the primary key constraint on table_name`. Given a :class:`_engine.Connection`, a string ``table_nam

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

A user-modifiable dictionary. The initial value of this dictionary can be populated using the ``info`` argument to the :class:`.Sessi

Specifies a DO NOTHING action for ON CONFLICT clause. :param index_elements: A sequence consisting of string column names,

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

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

Associate a SQL type with this mutable Python type. This establishes listeners that will detect ORM mappings against the given type,

Create a new :class:`_engine.URL` object. .. seealso:: :ref:`database_urls` :param drivername: the name of the database