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

Return a string describing an instance via its InstanceState.

Close this Session. This clears all items and ends any transaction in progress. If this session were created with ``autocommit=False

Compile a node or template source code. The `name` parameter is the load name of the template after it was joined using :meth:`join_p

Create a copy of this ``Column``, unitialized. This is used in ``Table.tometadata``.

Parse an expression. Per default all expressions are parsed, if the optional `with_condexpr` parameter is set to `False` conditional

specify a fixed VALUES clause for an INSERT statement, or the SET clause for an UPDATE. Note that the :class:`.Insert` and :class:`.U

Extend a numeric-type declaration with MySQL specific extensions.

Outdent by step.

Produce a conjunction of expressions joined by ``AND``. E.g.:: from sqlalchemy import and_ stmt = select([users_tab

Cycles among the arguments with the current loop index.

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

chain' an additional ClauseVisitor onto this ClauseVisitor. the chained visitor will receive all visit events after this one.

Return an unbound copy of this rule. This can be useful if you want to reuse an already bound URL for another map.

Walk the node and check for identifiers. If the scope is hard (eg: enforce on a python level) overrides from outer scopes are tracked

Remove a key. :param key: The key to be removed.

Connects a URL rule. Works exactly like the :meth:`route` decorator. If a view_func is provided it will be registered with the endpo

Instantiate model creation form and return it. Override to implement custom behavior.

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

Receive an instance when its constructor is called. This method is only called during a userland construction of an object. It is no

Conditionally quote an identifier. the 'force' flag should be considered deprecated.

Like :meth:`next_if` but only returns `True` or `False`.

Return the results represented by this ``Query`` as a list. This results in an execution of the underlying query.

Delegate an exception call to the underlying logger.

Get the current time. Used for test mocking/overriding mainly.

Works like :meth:`record` but wraps the function in another function that will ensure the function is only called once. If the bluepr

Delegate an error call to the underlying logger.

Execute a SQL expression construct or string statement within the current transaction. Returns a :class:`.ResultProxy` representing

Like :meth:`loads` but loads from a file.

traverse and visit the given expression structure.

Generates a URL to the given endpoint with the method provided. Variable arguments that are unknown to the target endpoint are appended to th

Given a :class:`.ColumnElement`, return the exported :class:`.ColumnElement` object from this :class:`.Selectable` which corresponds t

Return a dialect-specific implementation for this :class:`.TypeEngine`.

Return the full SELECT statement represented by this :class:`.Query`, converted to a scalar subquery with a label of the given name.

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

Renders a template from the template folder with the given context. :param template_name_or_list: the name of the template to be

Run del events, may eventually be inlined into decorators.

delete memoized collections when a FromClause is cloned.

Receive a scalar set event. :param target: the object instance receiving the event. If the listener is registered with ``raw=True``

Produce a UNION of this Query against one or more queries. e.g.:: q1 = sess.query(SomeClass).filter(SomeClass.foo=='bar')

URL encode a single string with a given encoding. :param s: the string to quote. :param charset: the charset to be used. :param safe: an