FilteredRequest
A request that can filter database rows.
protocol FilteredRequest
Browse conforming typesThe filter applies to the WHERE
clause, or to the ON
clause of an SQL join.
The WHERE and JOIN ON Clauses
func all(
) -> Self Returns
self
: a request that fetches all rows from this request.func filter(some SQLSpecificExpressible
) -> Self Filters the fetched rows with a boolean SQL expression.
func filter(literal: SQL
) -> Self Filters the fetched rows with an
SQL
literal.func filter(sql: String, arguments: StatementArguments
) -> Self Filters the fetched rows with an SQL string.
func filterWhenConnected(@escaping (Database) throws -> any SQLExpressible
) -> Self Filters the fetched rows with a boolean SQL expression.
func none(
) -> Self Returns an empty request that fetches no row.