{"library":"xsql","type":"library","category":null,"description":"XSQL is a SQL query builder library for Node.js supporting MySQL, MariaDB, SQLite, and PostgreSQL dialects. Version 1.0.1 provides a programmatic API to construct SQL queries using helper methods like x.select(), x.from(), x.where(), and x.join(). It handles identifier quoting, table aliasing, and schema prefixes per dialect. The library is minimal, has no dependencies, and focuses on building SELECT, INSERT, UPDATE, DELETE queries with nested functions, joins, and conditions. Released under MIT license, it receives infrequent updates. Compared to knex.js or squel, XSQL is lighter but requires more manual query assembly via string concatenation.","language":"javascript","status":"active","version":"1.0.1","tags":["javascript","sql","query","builder","mysql","mariadb","sqlite","postgresql","pg"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install xsql","imports":["import Xsql from 'xsql'","const x = new Xsql({dialect: 'mysql'})","import type { XsqlInstance } from 'xsql'"]},{"cmd":"yarn add xsql","imports":[]},{"cmd":"pnpm add xsql","imports":[]}],"homepage":"https://github.com/simov/xsql","github":"git://github.com/simov/xsql","docs":null,"changelog":null,"pypi":null,"npm":"xsql","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}