1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88
|
Selectables, Tables, FROM objects
=================================
The term "selectable" refers to any object that rows can be selected from;
in SQLAlchemy, these objects descend from :class:`.FromClause` and their
distinguishing feature is their :attr:`.FromClause.c` attribute, which is
a namespace of all the columns contained within the FROM clause (these
elements are themselves :class:`.ColumnElement` subclasses).
.. module:: sqlalchemy.sql.expression
.. autofunction:: alias
.. autofunction:: except_
.. autofunction:: except_all
.. autofunction:: exists
.. autofunction:: intersect
.. autofunction:: intersect_all
.. autofunction:: join
.. autofunction:: outerjoin
.. autofunction:: select
.. autofunction:: subquery
.. autofunction:: sqlalchemy.sql.expression.table
.. autofunction:: union
.. autofunction:: union_all
.. autoclass:: Alias
:members:
:inherited-members:
.. autoclass:: CompoundSelect
:members:
:inherited-members:
.. autoclass:: CTE
:members:
:inherited-members:
.. autoclass:: Executable
:members:
.. autoclass:: FromClause
:members:
.. autoclass:: GenerativeSelect
:members:
:inherited-members:
.. autoclass:: HasPrefixes
:members:
.. autoclass:: HasSuffixes
:members:
.. autoclass:: Join
:members:
:inherited-members:
.. autoclass:: ScalarSelect
:members:
.. autoclass:: Select
:members:
:inherited-members:
.. autoclass:: Selectable
:members:
.. autoclass:: SelectBase
:members:
.. autoclass:: TableClause
:members:
:inherited-members:
.. autoclass:: TextAsFrom
:members:
|