Function compileSQLite

packages/powersync-db-collection/src/sqlite-compiler.ts:45–67

(
  options: LoadSubsetOptions,
  compileOptions?: CompileSQLiteOptions,
)

 * ```
 */
export function compileSQLite(
  options: LoadSubsetOptions,
  compileOptions?: CompileSQLiteOptions,
): SQLiteCompiledQuery {
  const { where, orderBy, limit } = options

  const params: Array<unknown> = []
  const result: SQLiteCompiledQuery = { params }

  if (where) {
    result.where = compileExpression(where, params, compileOptions)
  }

  if (orderBy) {
    result.orderBy = compileOrderBy(orderBy, params, compileOptions)
  }

  if (limit !== undefined) {
    result.limit = limit
  }

  return result
}

/**
 * Quote SQLite identifiers to handle column names correctly.