return a new :class:`_engine.URL` object with modifications. Values are used if they are non-None. To set a value to ``None`` explic

Return True if the given :class:`_expression.ColumnElement` has a common ancestor to this :class:`_expression.ColumnElement`.

Extend a string-type declaration with standard SQL CHARACTER SET / COLLATE annotations and MySQL specific extensions.

Force this InstanceState to act as though its weakref has been GC'ed. this is used for test code that has to test reactions to object

Compile a string to regex, I and UNICODE.

indicate that this query applies to objects loaded within a certain path. Used by deferred loaders (see strategies.py) which transfer

Add an entity to the collection, firing mutation events.

Produce an column-expression-level unary ``DISTINCT`` clause. This applies the ``DISTINCT`` keyword to an **individual column expression** (e

Return a list of all materialized view names available in the database. This is an internal dialect method. Applications should use

Return exactly one instance based on the given primary key identifier, or raise an exception if not found. Raises :class:`_exc.NoResu

Return a schema objects of the given kind and name if found. This method can be used to return :class:`_sqltypes.Enum`, :class:`.Sequ

Return True if this :class:`_orm.Session` has begun a nested transaction, e.g. SAVEPOINT. .. versionadded:: 1.4

Provides a surrogate :class:`_schema.Column` that will act as a dedicated insert :term:`sentinel` column, allowing efficient bulk inserts with

Alter the state of the given instance so that it is :term:`transient`. .. note:: :func:`.make_transient` is a special-case function for

Return True if the given object is a mapped class, :class:`_orm.Mapper`, or :class:`.AliasedClass`.

Return all remaining rows as plain processed tuples, as produced by the ``interim_rows`` element of :attr:`._row_getter`; :class:`.Row

Populate from the listeners in another :class:`_Dispatch` object.

Return a "read only" form of this :class:`_sql.WriteableColumnCollection`.

legacy adapter function for functions that were previously using assert_raises with SAWarning or similar. has some workarounds to accommodate

Return a DBAPI connection from the pool. The connection is instrumented such that when its ``close()`` method is called, the connecti

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

Remove and return an item from the queue. If optional args `block` is True and `timeout` is None (the default), block if necessary un

Return the current **actual** isolation level that's present on the database within the scope of this connection. This attribute will

Return a dictionary of options specified when ``table_name`` was created. This is an internal dialect method. Applications should use

Return the identity key for the mapped object. This is the key used to locate the object within the :attr:`.Session.identity_map` map

Return a :class:`_expression.Lateral` object. :class:`_expression.Lateral` is an :class:`_expression.Alias` subclass that represents a su

r"""Translate url attributes into a dictionary of connection arguments. Returns attributes of this url (`host`, `database`, `username`,

Transform a generic type to a dialect-specific type. Dialect classes will usually use the :func:`_types.adapt_type` function in the t