{"library":"tougo-query-builder","type":"library","category":null,"description":"A lightweight JavaScript query builder for PostgreSQL that constructs raw SQL queries programmatically. Version 1.3.7 is current, with a dependency on the 'pg' package added in 1.3.5 allowing direct database queries from Express routes. It supports SELECT, FROM, JOIN, WHERE, UPDATE, and spatial functions (ST_Transform, ST_GeomFromText). Distinctive for its minimal API and optional direct query execution via connection string, but lacks TypeScript types and modern ESM support. Suitable for small projects needing simple SQL generation without an ORM.","language":"javascript","status":"active","version":"1.3.7","tags":["javascript","postgres","query","tougo"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install tougo-query-builder","imports":["var qb = require('tougo-query-builder');","var qsp = new qb.spatial;","var q = qb.select('*').from('property').query;"]},{"cmd":"yarn add tougo-query-builder","imports":[]},{"cmd":"pnpm add tougo-query-builder","imports":[]}],"homepage":null,"github":null,"docs":null,"changelog":null,"pypi":null,"npm":"tougo-query-builder","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}