Protected_Protected_Protected_Protected_Protected_StaticPKEY_The string identifier for primary keys, mapped to 'id' by default.
Protected_Convert array into SQL expression
Array of strings or numbers
string
Protected_Resolves the canonical database path for a record, respecting standard collection structures and hierarchical subcollection configurations.
Optionaluid: stringProtected_Protected_Process data for compatibility
Protected_Processes raw data entries to convert relational reference objects into native database foreign key IDs
if the adapter has been configured with useNativeForeignKeys = true.
Executes an aggregation operation (sum, avg, distinct, min, max, count) on a query. The default implementation fetches all matching records and performs in-memory aggregation. Specific database adapters should override this to perform native query aggregation.
The Query instance defining the collection and filters.
The aggregate operation.
Optionalproperty: stringThe name of the property to aggregate.
A promise resolving to the aggregated result.
Close the SQLite connection
Translates a DataObject creation request into an INSERT INTO SQL query.
SQLite handles JSON by parsing array properties internally.
The DataObject payload.
Optional explicit UUID.
A promise resolving to the saved DataObject.
Generates a DELETE FROM or UPDATE query depending on the hardDelete parameter.
The DataObject to remove.
Force permanent deletion over soft delete.
A promise resolving upon completion.
Wipes all records from a table by executing a blanket DELETE FROM.
The table name to purge.
Ignored for SQLite bulk deletes.
Removes a middleware from the pipeline by its class name.
The exact name of the middleware class to remove.
Orchestrates the sequential execution of all attached middlewares for a given action.
The payload traversing the middlewares.
The context (READ, CREATE, UPDATE, DELETE).
Whether to run the before or after pipeline.
Optionalparams: MiddlewareParamsOptional parameters passed down to the middlewares.
A promise resolving to the potentially mutated DataObject.
Translates the Quatrain Filters logic into SQLite query syntax.
Employs internal json_each extensions for Array-contains searches when JSON1 is available.
The targeted collection object.
Requested Query filters.
Query Limits & Pagination rules.
Optional parent linkage.
A promise resolving to hydrated objects and metadata.
Generates the SQL up and down statements to create a collection table.
Generates the SQL up and down statements to apply a schema delta to a collection.
Helper method to extract the destination collection name from a DataObject.
The DataObject evaluating the context.
The resolved collection string.
Retrieves a specific configuration parameter.
The parameter key to fetch.
The value associated with the key, or undefined.
Returns true if a given middleware is attached
boolean
Process Query instance and return result
Array
Executes an arbitrary raw SQL query against the SQLite database.
The SQL statement with optional ? parameterized placeholders.
The array of parameter values.
A promise resolving to the SQLite result rows.
Executes a SELECT * query to retrieve a document by its UID.
Handles mapping of JSON text columns back into arrays/objects.
The empty DataObject containing the target path.
A promise resolving to the hydrated DataObject.
Overrides or adds a backend configuration parameter dynamically.
The parameter key to modify.
The new value to assign.
Processes an UPDATE command for modified object properties.
Automatically ensures the table exists and properly escapes JSON-backed properties.
The modified DataObject.
A promise resolving to the updated instance.
Backend adapter implementation for SQLite databases. Uses the
sqlitedriver to provide a fast, local relational store without external dependencies. Highly useful for local development, CI/CD testing environments, or lightweight local deployments.