Module sqlalchemy_builder.select

Sqlalchemy Select methods redefined statically.

The documentation and functionality is the same as Select methods from sqlalchemy. But here they are used statically and supports | and |= operators.

from sqlalchemy_builder import select, where, order_by

stmt = select(MyModel) | where(MyModel.x == 1)
stmt |= order_by(MyModel.id)

NOTE: Only use with base select, GenerativeSelect and CompoundSelect may not work correctly.

The following sqlalchemy operations are available:

• where
• join
• filter
• filter_by
• having
• group_by
• order_by
• offset
• limit
• add_cte
• options
• execution_options
• outerjoin
• join_from
• outerjoin_from
• distinct
• correlate
• correlate_except