Documentation

Supply of fresh reference names to be used in monadic contexts where you need an infinite-ish supply.

Alter a pre-existing Query monadically.

Define a subquery using the WITH syntax. Note that this does not automatically include this table in a SELECT; you need to additionally include the resulting relation from withQ_ using the from_ operator.

Define a WITH subquery while retaining and re-using its given name. Useful in some scenarios where you want to keep the original name in further referring to the newly introduced subquery table.

Use unique naming scheme along with Ref Relation to construct the WITH macro's name. This is useful when ensuring unique naming while not throwing out some human-readable information.

Smart selector that will use the variable's name if expression is a variable and assign a fresh variable name if it's something else without a name.

Add optional aliasing to the Q.

Select a field and also include it in GROUP BY. Do this intelligently, referring to it by its given name in most cases but by its direct expression definition in case of external functions to prevent overlap with fields that may already exist.

Like selectsGroupsAs_ but will use the name you gave to each field in the group by statement. Some backends like BigQuery require this while others like Redshift don't like it.

Special convenience case: Select and group while demanding that none of the group values is null.

Add a from clause unless the relation is already in place.

Use a name directly and don't alias it one more time. | This can fail to create a proper alias if the Ref includes multiple names.

Returns True iff the current Query already has an initial From table available.

where x in y

where x not in y

Turn query into relation

Make a query relation that applies predicate on the given relation in a subquery.

Introspects the given list of Queryies, along with their references in the current context, and selects every named field in them within the current context, while deduplicating repeat fields (by name). Good for the common case of joining tables and selecting everything possible in them.

Instead of doing a select * that's impossible to introspect, explicitly select all fields from something that contains a definition - e.g. a Query.

select * from x

Given a list of references, select those that have not yet been selected in current monadic block.

Given a list of references, select those that have not yet been selected in current monadic block with option to modify the finalized selection.