{"library":"sqlite-simplifier","type":"library","category":null,"description":"A type-safe, fluent SQLite query builder for React Native and Node.js (≥16), wrapping react-native-sqlite-storage. Current stable version: 1.0.3. Provides a clean builder API with features like select, join, aggregate functions (COUNT, SUM, AVG, MIN, MAX), advanced WHERE conditions (IN, BETWEEN, OR), duplicate query blocking, query caching, and SQL injection protection. Ships TypeScript types. Differentiators vs knex: focused on React Native, simpler API, built-in caching and deduplication. Release cadence: early stage, infrequent updates.","language":"javascript","status":"active","version":"1.0.3","tags":["javascript","react-native","react-native-sqlite-storage","sqlite","sqlite3","database","query-builder","offline-first","storage","typescript"],"last_verified":"Sun Jun 07","install":[{"cmd":"npm install sqlite-simplifier","imports":["import { createAdvancedQuery } from 'sqlite-simplifier'","import { where, orWhere } from 'sqlite-simplifier'","import { createAdvancedQuery } from 'sqlite-simplifier'; const query = createAdvancedQuery(db, true); const result = await query.query('transactions').select('id').get();"]},{"cmd":"yarn add sqlite-simplifier","imports":[]},{"cmd":"pnpm add sqlite-simplifier","imports":[]}],"homepage":"https://github.com/oyeeshadab/sqlite-simplifier#readme","github":"https://github.com/oyeeshadab/sqlite-simplifier","docs":null,"changelog":null,"pypi":null,"npm":"sqlite-simplifier","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}