Skip to content
Source
Sign inSign up
TanStack/db
Open History to see the last commit

SQLiteCompiledQuery.md

58 lines1.2 KB

1---
2id: SQLiteCompiledQuery
3title: SQLiteCompiledQuery
4---
5​
6# Interface: SQLiteCompiledQuery
7​
8Defined in: [sqlite-compiler.ts:6](https://github.com/TanStack/db/blob/main/packages/powersync-db-collection/src/sqlite-compiler.ts#L6)
9​
10Result of compiling LoadSubsetOptions to SQLite
11​
12## Properties
13​
14### limit?
15​
16```ts
17optional limit: number;
18```
19​
20Defined in: [sqlite-compiler.ts:12](https://github.com/TanStack/db/blob/main/packages/powersync-db-collection/src/sqlite-compiler.ts#L12)
21​
22The LIMIT value
23​
24***
25​
26### orderBy?
27​
28```ts
29optional orderBy: string;
30```
31​
32Defined in: [sqlite-compiler.ts:10](https://github.com/TanStack/db/blob/main/packages/powersync-db-collection/src/sqlite-compiler.ts#L10)
33​
34The ORDER BY clause (without "ORDER BY" keyword), e.g., "price DESC"
35​
36***
37​
38### params
39​
40```ts
41params: unknown[];
42```
43​
44Defined in: [sqlite-compiler.ts:14](https://github.com/TanStack/db/blob/main/packages/powersync-db-collection/src/sqlite-compiler.ts#L14)
45​
46Parameter values in order, to be passed to SQLite query
47​
48***
49​
50### where?
51​
52```ts
53optional where: string;
54```
55​
56Defined in: [sqlite-compiler.ts:8](https://github.com/TanStack/db/blob/main/packages/powersync-db-collection/src/sqlite-compiler.ts#L8)
57​
58The WHERE clause (without "WHERE" keyword), e.g., "price > ?"