DB Docs
API Reference
- Core API Reference
- Collection
- createCollection
- liveQueryCollectionOptions
- createLiveQueryCollection
- createOptimisticAction
- createTransaction
- Electric DB Collection
- electricCollectionOptions
- Query DB Collection
- queryCollectionOptions
- RxDB DB Collection
- rxdbCollectionOptions
- PowerSync Collection
- powerSyncCollectionOptions
- createIndexedDB
- indexedDBCollectionOptions
- React Hooks
- useLiveQuery
AI/LLM: This documentation page is available in plain markdown format at/db/latest/docs/reference/powersync-db-collection/interfaces/SQLiteCompiledQuery.md
SQLiteCompiledQuery
Defined in: sqlite-compiler.ts:6
Result of compiling LoadSubsetOptions to SQLite
Properties#
limit?#
ts
optional limit: number;Defined in: sqlite-compiler.ts:12
The LIMIT value
orderBy?#
ts
optional orderBy: string;Defined in: sqlite-compiler.ts:10
The ORDER BY clause (without "ORDER BY" keyword), e.g., "price DESC"
params#
ts
params: unknown[];Defined in: sqlite-compiler.ts:14
Parameter values in order, to be passed to SQLite query
where?#
ts
optional where: string;Defined in: sqlite-compiler.ts:8
The WHERE clause (without "WHERE" keyword), e.g., "price > ?"