{"id":43875,"library":"sql-bricks-sqlite","title":"SQL-Bricks-SQLite","description":"SQL-Bricks-SQLite (v1.0.0) extends the core sql-bricks library with SQLite-specific SQL generation functions such as LIMIT, OFFSET, OR REPLACE, OR ABORT, and other SQLite dialect features. It provides a transparent, schemaless builder for SELECT, INSERT, UPDATE, and DELETE statements targetting SQLite. The package has no dependencies other than sql-bricks itself. It is released as a stable package but is in maintenance mode with infrequent updates. Key differentiator: seamless integration with sql-bricks for developers already using that library.","status":"maintenance","version":"1.0.0","language":"javascript","source_language":"en","source_url":"https://github.com/CSNW/sql-bricks-sqlite","tags":["javascript","sql","generation","generate","query","sqlite","builder","select","insert"],"install":[{"cmd":"npm install sql-bricks-sqlite","lang":"bash","label":"npm"},{"cmd":"yarn add sql-bricks-sqlite","lang":"bash","label":"yarn"},{"cmd":"pnpm add sql-bricks-sqlite","lang":"bash","label":"pnpm"}],"dependencies":[{"reason":"Core SQL generation library; this package provides SQLite dialect extensions.","package":"sql-bricks","optional":false}],"imports":[{"note":"Modern ESM import; for CommonJS use require('sql-bricks-sqlite').","wrong":"const sql = require('sql-bricks-sqlite')","symbol":"default","correct":"import sql from 'sql-bricks-sqlite'"},{"note":"Named export available for ESM; CommonJS require also works.","wrong":"const { select } = require('sql-bricks-sqlite')","symbol":"select","correct":"import { select } from 'sql-bricks-sqlite'"},{"note":"SQLiteBricks is a global for browser UMD builds, not a module export.","wrong":"import SQLiteBricks from 'sql-bricks-sqlite'","symbol":"SQLiteBricks","correct":"// Browser global: var sql = SQLiteBricks;"}],"quickstart":{"code":"import sql from 'sql-bricks-sqlite';\n\n// Build a query with SQLite-specific clauses\nconst stmt = sql.select('name', 'age')\n  .from('users')\n  .where({ name: { $like: '%Fred%' } })\n  .limit(10)\n  .offset(20);\n\nconsole.log(stmt.toString());\n// Output: SELECT name, age FROM users WHERE name LIKE '%Fred%' LIMIT 10 OFFSET 20","lang":"javascript","description":"Shows basic SELECT with SQLite LIMIT and OFFSET using the sql-bricks-sqlite builder."},"warnings":[{"fix":"npm install sql-bricks@^2.0.0","message":"Requires sql-bricks as a peer dependency at version >=2.0.","severity":"breaking","affected_versions":">=1.0"},{"fix":"Consider using a more actively maintained alternative like knex.","message":"The package is in maintenance mode and may not receive updates for newer SQLite features.","severity":"deprecated","affected_versions":">=1.0"},{"fix":"Use the UMD bundle and reference the global, or use a bundler with CommonJS/ESM.","message":"Browser usage expects global `SQLiteBricks`; not a typical module export.","severity":"gotcha","affected_versions":">=1.0"},{"fix":"Always use parameterized objects or `sql()` template literals if available.","message":"`sql-bricks-sqlite` does not sanitize input; raw strings in `.where` may lead to SQL injection.","severity":"gotcha","affected_versions":">=1.0"}],"env_vars":null,"search_vec":"'abort':31 'alreadi':88 'brick':3,7,15,61,85 'builder':42,98 'core':12 'delet':48 'depend':56 'develop':87 'dialect':35 'differenti':79 'extend':10 'featur':36 'function':23 'generat':22,94,95 'infrequ':76 'insert':45,100 'integr':81 'javascript':92 'key':78 'librari':16,91 'limit':26 'mainten':73 'mode':74 'offset':27 'packag':53,69 'provid':38 'queri':96 'releas':65 'replac':29 'schemaless':41 'seamless':80 'select':44,99 'specif':20 'sql':2,6,14,21,60,84,93 'sql-brick':13,59,83 'sql-bricks-sqlit':1,5 'sqlite':4,8,19,34,51,97 'sqlite-specif':18 'stabl':68 'statement':49 'target':50 'transpar':40 'updat':46,77 'use':89 'v1.0.0':9","created_at":"2026-06-05T17:01:54.111068+00:00","updated_at":"2026-06-05T17:01:54.111068+00:00","problems":[{"fix":"Run npm install sql-bricks","cause":"Missing peer dependency sql-bricks.","error":"Cannot find module 'sql-bricks'"},{"fix":"Use the UMD bundle and access `SQLiteBricks` global, or use a module bundler.","cause":"Incorrect import style in browser (library not loaded).","error":"sql.select is not a function"}],"ecosystem":"npm","meta_description":null,"install_score":null,"quickstart_score":null,"quickstart_tag":null,"pypi_latest":null,"cli_name":null,"cli_version":null,"type":"library","homepage":"https://github.com/CSNW/sql-bricks-sqlite","github":"https://github.com/CSNW/sql-bricks-sqlite","docs":null,"changelog":null,"pypi":null,"npm":"sql-bricks-sqlite","openapi_spec":null,"status_page":null,"smithery":null,"categories":["database"],"base_url":null,"auth_type":null,"provenance":{"verified_status":null,"verified_at":null,"last_verified":"2026-06-05","next_check":"2026-09-03","install_tag":null}}