{"library":"selectstar","type":"library","category":null,"description":"Selectstar is a JavaScript/TypeScript library for generating safe, parameterized SQL queries for PostgreSQL using tagged template literals. Current stable version is 1.1.11, maintained since 2018. It provides primitives for constructing dynamic queries without SQL injection risks: parameterized values, query fragments (template), dynamic identifiers, and lists. Unlike alternatives like squel or knex, selectstar stays close to raw SQL syntax while enforcing parameterization — it is ignorant of query semantics, making it ideal for complex or raw SQL generation. It is fully typed (TypeScript declarations included) and integrates directly with node-postgres (pg) via query objects containing text and values. The package has no runtime dependencies.","language":"javascript","status":"active","version":"1.1.11","tags":["javascript","sql","postgres","postgresql","node-postgres","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install selectstar","imports":["import { sql } from 'selectstar'","import { template } from 'selectstar'","import { identifier } from 'selectstar'","import { list } from 'selectstar'","import type { Query } from 'selectstar'"]},{"cmd":"yarn add selectstar","imports":[]},{"cmd":"pnpm add selectstar","imports":[]}],"homepage":"https://github.com/faradayio/selectstar#readme","github":"https://github.com/faradayio/selectstar","docs":null,"changelog":null,"pypi":null,"npm":"selectstar","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}