{"library":"sql-fmt","type":"library","category":null,"description":"A MySQL query builder and SQL string formatting library that provides template literal-based SQL escaping and object-to-SQL conversion. Current stable version is 2.1.0. It wraps sqlstring for escaping and offers helper functions like insert, where, set, and values to safely build SQL from JavaScript objects. Key differentiators include automatic detection of template usage (e.g., objects become WHERE or SET clauses) and a prefix '#' to bypass escaping for trusted strings. Release cadence is low; the package is maintained primarily for personal use with notable limitations in documentation consistency.","language":"javascript","status":"active","version":"2.1.0","tags":["javascript","typescript"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install sql-fmt","imports":["import sql from 'sql-fmt'","import sql from 'sql-fmt'; sql.escape(value)","import sql from 'sql-fmt'; sql.escapeId(identifier)"]},{"cmd":"yarn add sql-fmt","imports":[]},{"cmd":"pnpm add sql-fmt","imports":[]}],"homepage":"git+https://github.com/ymzuiku/sql-fmt.git","github":"https://github.com/ymzuiku/sql-fmt","docs":null,"changelog":null,"pypi":null,"npm":"sql-fmt","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}