{"library":"sql-bricks","type":"library","category":null,"description":"SQL Bricks.js is a transparent, schemaless library for building and composing SQL-92 statements (SELECT, INSERT, UPDATE, DELETE) in JavaScript. Current stable version is 3.0.1. It has no production dependencies, single file (~1,100 lines), over 200 tests, and ships TypeScript types. Compared to Knex (20k lines, schema-based) and Squel (1.7k lines), sql-bricks offers a minimal, zero-dependency alternative with dialect-specific extensions for PostgreSQL, MySQL, and SQLite via separate packages.","language":"javascript","status":"active","version":"3.0.1","tags":["javascript","sql","generation","generate","query","pg","postgres","sqlite","builder","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-bricks","imports":["import { select } from 'sql-bricks'","import { insert } from 'sql-bricks'","import * as SqlBricks from 'sql-bricks'","const query = select().from('table').toParams()"]},{"cmd":"yarn add sql-bricks","imports":[]},{"cmd":"pnpm add sql-bricks","imports":[]}],"homepage":"http://csnw.github.io/sql-bricks","github":"https://github.com/CSNW/sql-bricks","docs":null,"changelog":null,"pypi":null,"npm":"sql-bricks","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}