Filters the fetched rows with an SQL string.
func filter(sql: String, arguments: StatementArguments = StatementArguments()) -> Self s4GRDB15FilteredRequestPAAE6filter3sql9argumentsxSS_AA18StatementArgumentsVtF What are these?4MU0SFor example:
// SELECT * FROM player WHERE name = 'O''Brien'
let name = "O'Brien"
let request = Player.all().filter(sql: "name = ?", arguments: [name])import GRDBA toolkit for SQLite databases, with a focus on application development
protocol FilteredRequestA request that can filter database rows.
@frozen struct StringA Unicode string value that is a collection of characters.
struct StatementArgumentsAn instance of StatementArguments provides the values for argument placeholders in a prepared Statement.
func all() -> Self Returns self: a request that fetches all rows from this request.
func filter(_ predicate: some SQLSpecificExpressible) -> Self Filters the fetched rows with a boolean SQL expression.
func filter(id: RowDecoder.ID) -> Self Filters by primary key.
func filter(ids: some Collection<RowDecoder.ID>) -> Self Filters by primary key.
func filter(key: some DatabaseValueConvertible) -> Self Filters by primary key.
func filter(key: [String : (any DatabaseValueConvertible)?]?) -> Self Filters by primary or unique key.
func filter<Keys>(keys: Keys) -> Self where Keys : Collection, Keys.Element : DatabaseValueConvertible Filters by primary key.
func filter(keys: [[String : (any DatabaseValueConvertible)?]]) -> Self Filters by primary or unique key.
func filter(literal sqlLiteral: SQL) -> Self Filters the fetched rows with an SQL literal.
func filterWhenConnected(_ predicate: @escaping (Database) throws -> any SQLExpressible) -> Self Filters the fetched rows with a boolean SQL expression.
func matching(_ pattern: FTS3Pattern?) -> Self Filters rows that match an FTS3 full-text pattern.
func matching(_ pattern: FTS5Pattern?) -> Self Filters rows that match an FTS5 full-text pattern.
func none() -> Self Returns an empty request that fetches no row.