function compileSQLite(options, compileOptions?): SQLiteCompiledQuery;
Defined in: sqlite-compiler.ts:45
Compiles TanStack DB LoadSubsetOptions to SQLite query components.
LoadSubsetOptions
const compiled = compileSQLite({
where: { type: 'func', name: 'gt', args: [
{ type: 'ref', path: ['price'] },
{ type: 'val', value: 100 }
]},
orderBy: [{ expression: { type: 'ref', path: ['price'] }, compareOptions: { direction: 'desc', nulls: 'last' } }],
limit: 50
})
// Result: { where: '"price" > ?', orderBy: '"price" DESC', limit: 50, params: [100] }