{"library":"sql-bricks-postgres","type":"library","category":null,"description":"A lightweight, schemaless SQL generation library for PostgreSQL, built on top of sql-bricks. It adds PostgreSQL-specific features such as LIMIT/OFFSET, RETURNING, UPDATE...FROM, DELETE...USING, ON CONFLICT (UPSERT), and FROM VALUES. Version 0.6.0 is stable but sees infrequent releases. Key differentiator: provides a fluent API for generating parameterized SQL with PostgreSQL syntax, using $1, $2 placeholders for safe execution via database libraries. Designed for use with pg-bricks for query execution, but can be used standalone.","language":"javascript","status":"active","version":"0.6.0","tags":["javascript","sql","generation","generate","query","pg","postgres","builder","select"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-bricks-postgres","imports":["const sql = require('sql-bricks-postgres');","import sql from 'sql-bricks-postgres';"]},{"cmd":"yarn add sql-bricks-postgres","imports":[]},{"cmd":"pnpm add sql-bricks-postgres","imports":[]}],"homepage":"https://github.com/Suor/sql-bricks-postgres","github":"https://github.com/Suor/sql-bricks-postgres","docs":null,"changelog":null,"pypi":null,"npm":"sql-bricks-postgres","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}