Returns a new QueryInterfaceRequest with a matching predicate added to the eventual set of already applied predicates.

// SELECT * FROM books WHERE books MATCH '...'
var request = Book.all()
request = request.matching(pattern)

If the search pattern is nil, the request does not match any database row.

This function is an implementation detail of the query interface. Do not use it directly.

See https://github.com/groue/GRDB.swift/#the-query-interface

Low Level Query Interface

See SQLSelectQuery.selectQuerySQL(_)

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM persons
var request = Person.all()
request = request.select(Column("id"), Column("email"))

Any previous selection is replaced:

// SELECT email FROM persons
request
    .select(Column("id"))
    .select(Column("email"))

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM persons
var request = Person.all()
request = request.select([Column("id"), Column("email")])

Any previous selection is replaced:

// SELECT email FROM persons
request
    .select([Column("id")])
    .select([Column("email")])

A new QueryInterfaceRequest with a new net of selected columns.

// SELECT id, email FROM persons
var request = Person.all()
request = request.select(sql: "id, email")

Any previous selection is replaced:

// SELECT email FROM persons
request
    .select(sql: "id")
    .select(sql: "email")

A new QueryInterfaceRequest which returns distinct rows.

// SELECT DISTINCT * FROM persons
var request = Person.all()
request = request.distinct()

// SELECT DISTINCT name FROM persons
var request = Person.select(Column("name"))
request = request.distinct()

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

// SELECT * FROM persons WHERE email = 'arthur@example.com'
var request = Person.all()
request = request.filter(Column("email") == "arthur@example.com")

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

// SELECT * FROM persons WHERE email = 'arthur@example.com'
var request = Person.all()
request = request.filter(sql: "email = ?", arguments: ["arthur@example.com"])

A new QueryInterfaceRequest grouped according to expressions.

A new QueryInterfaceRequest grouped according to expressions.

A new QueryInterfaceRequest with a new grouping.

A new QueryInterfaceRequest with the provided predicate added to the eventual set of already applied predicates.

A new QueryInterfaceRequest with the provided sql added to the eventual set of already applied predicates.

A new QueryInterfaceRequest with the provided orderings.

// SELECT * FROM persons ORDER BY name
var request = Person.all()
request = request.order(Column("name"))

Any previous ordering is replaced:

// SELECT * FROM persons ORDER BY name
request
    .order(Column("email"))
    .order(Column("name"))

A new QueryInterfaceRequest with the provided orderings.

// SELECT * FROM persons ORDER BY name
var request = Person.all()
request = request.order([Column("name")])

Any previous ordering is replaced:

// SELECT * FROM persons ORDER BY name
request
    .order([Column("email")])
    .order([Column("name")])

A new QueryInterfaceRequest with the provided sql used for sorting.

// SELECT * FROM persons ORDER BY name
var request = Person.all()
request = request.order(sql: "name")

Any previous ordering is replaced:

// SELECT * FROM persons ORDER BY name
request
    .order(sql: "email")
    .order(sql: "name")

A new QueryInterfaceRequest sorted in reversed order.

// SELECT * FROM persons ORDER BY name DESC
var request = Person.all().order(Column("name"))
request = request.reversed()

A QueryInterfaceRequest which fetches limit rows, starting at offset.

// SELECT * FROM persons LIMIT 1
var request = Person.all()
request = request.limit(1)

The number of rows fetched by the request.

Deletes matching rows; returns the number of deleted rows.