Selectables, Tables, FROM objects

The term “selectable” refers to any object that rows can be selected from; in SQLAlchemy, these objects descend from FromClause and their distinguishing feature is their 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.

Object Name Description

LABEL_STYLE_DEFAULT

The default label style, refers to LABEL_STYLE_DISAMBIGUATE_ONLY.

sqlalchemy.sql.expression.LABEL_STYLE_DEFAULT

The default label style, refers to LABEL_STYLE_DISAMBIGUATE_ONLY.

New in version 1.4.

See also

Select.set_label_style()

Select.get_label_style()

Back to Top