Database.Beam.Query.CTE

Monad in which SELECT statements can be made (via selecting) and bound to result names for re-use later. This has the advantage of only computing each result once. In SQL, this is translated to a common table expression.

Once introduced, results can be re-used in future queries with reuse.

With is also a member of MonadFix for backends that support recursive CTEs. In this case, you can use mdo or rec notation (with RecursiveDo enabled) to bind result values (again, using reuse) even before they're introduced.

See further documentation here.

Query results that have been introduced into a common table expression via selecting that can be used in future queries with reuse.

Introduce the result of a query as a result in a common table expression. The returned value can be used in future queries by applying reuse.

Introduces the result of a previous selecting (a CTE) into a new query