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