Filtering, ordering, pagination

Querying

Chain after .getAll():

const notes = await db.from('notes').getAll().filter({ completed: true });

Method: filter(conditions)
Supported Operators: eq, neq, gt, gte, lt, lte, like, ilike, in, not (see list of operators)

const ordered = await db.from('notes').getAll().order('created_at', 'desc');

const paged = await db.from('notes').getAll().limit(10).offset(10);

Note: All these must be chained after .getAll().

All used within filter():

Operator	Description	Example
`eq`	Equality	`.filter({ status: { eq: "active" } })`
`neq`	Not equal	`.filter({ status: { neq: "deleted" } })`
`gt`	Greater than	`.filter({ priority: { gt: 3 } })`
`gte`	Greater than or equal	`.filter({ priority: { gte: 3 } })`
`lt`	Less than	`.filter({ priority: { lt: 3 } })`
`lte`	Less than or equal	`.filter({ priority: { lte: 3 } })`
`like`	Pattern (case sensitive)	`.filter({ title: { like: "%project%" } })`
`ilike`	Pattern (case insensitive)	`.filter({ title: { ilike: "%todo%" } })`
`in`	Value in set	`.filter({ tags: { in: ["work", "important"] } })`
`not`	Negation	`.filter({ tags: { not: { eq: "work" } } })`

Only one filterable condition per field per query (no compound filters across multiple fields)
Range filters (e.g., { gte: x, lte: y }) not supported
Method chaining order is flexible, but all must be chained after getAll()