with

fun with(name: String, query: String): R

Adds a query to the WITH clause (Common Table Expression).

Parameters

name

Name (alias) for the CTE.

query

SQL query defining the CTE.