SELECT and Related Constructs¶
The term “selectable” refers to any object that represents database rows. In
SQLAlchemy, these objects descend from Selectable, the
most prominent being Select, which represents a SQL SELECT
statement. A subset of Selectable is
FromClause, which represents objects that can be within
the FROM clause of a Select statement. A distinguishing feature of
FromClause is the FromClause.c
attribute, which is a namespace of all the columns contained within the FROM
clause (these elements are themselves ColumnElement
subclasses).
Selectable Foundational Constructors¶
Top level “FROM clause” and “SELECT” constructors.
Selectable Modifier Constructors¶
Functions listed here are more commonly available as methods from
FromClause and Selectable elements, for example,
the alias() function is usually invoked via the
FromClause.alias() method.
Selectable Class Documentation¶
The classes here are generated using the constructors listed at Selectable Foundational Constructors and Selectable Modifier Constructors.
Label Style Constants¶
Constants used with the GenerativeSelect.set_label_style()
method.
See also
Select.set_label_style()
Select.get_label_style()