sqlalchemy.sql.dml.DMLWhereBase

Method	`_filter_by_zero`	Undocumented
Method	`filter`	A synonym for the `_dml.DMLWhereBase.where` method.
Method	`filter_by`	apply the given filtering criterion as a WHERE clause to this select.
Method	`where`	Return a new construct with the given expression(s) added to its WHERE clause, joined to the existing clause via AND, if any.
Class Variable	`_where_criteria`	Undocumented
Property	`whereclause`	Return the completed WHERE clause for this `.DMLWhereBase` statement.

def _filter_by_zero(self):

Undocumented

def filter(self, *criteria):

A synonym for the _dml.DMLWhereBase.where method.

New in version 1.4.

def filter_by(self, **kwargs):

apply the given filtering criterion as a WHERE clause to this select.

@_generative
def where(self, *whereclause):

Return a new construct with the given expression(s) added to its WHERE clause, joined to the existing clause via AND, if any.

Both _dml.Update.where and _dml.Delete.where support multiple-table forms, including database-specific UPDATE...FROM as well as DELETE..USING. For backends that don't have multiple-table support, a backend agnostic approach to using multiple tables is to make use of correlated subqueries. See the linked tutorial sections below for examples.