{"library":"sqlqueryhelperjs","title":"SQLQueryHelperjs","type":"library","description":"Runtime database evolution engine for SQL systems (SQLite, PostgreSQL, MySQL) that lets you define schemas in code, reflect existing databases, and synchronize structure automatically. Version 1.2.6 (stable, active development) combines ORM-like schema definitions, automatic migration-less evolution, fluent SQL builder with joins/CTEs/window functions, and legacy DB inspection into one package. Unlike typical ORMs, it preserves full SQL control while handling schema changes safely. Ships TypeScript types and supports both ESM and CommonJS.","language":"javascript","status":"active","last_verified":"Fri May 01","install":{"commands":["npm install sqlqueryhelperjs"],"cli":null},"imports":["import { SqliteReflector } from 'sqlqueryhelperjs'","import { column } from 'sqlqueryhelperjs'","import { entity } from 'sqlqueryhelperjs'","import { primaryKey } from 'sqlqueryhelperjs'","import { PostgresReflector } from 'sqlqueryhelperjs'","import { MysqlReflector } from 'sqlqueryhelperjs'"],"auth":{"required":false,"env_vars":[]},"links":{"homepage":"https://jgabocc.github.io/SQLQueryHelperJs/","github":"https://github.com/jgabocc/SQLQueryHelperJs","docs":null,"changelog":null,"pypi":null,"npm":"https://www.npmjs.com/package/sqlqueryhelperjs","openapi_spec":null,"status_page":null,"smithery":null},"quickstart":{"code":"import { SqliteReflector, column, entity, primaryKey } from 'sqlqueryhelperjs';\n\nclass User {\n  static entity = entity({\n    table: 'users',\n    columns: {\n      id: column.integer(),\n      email: column.text({ nullable: false }),\n    },\n    primaryKey: primaryKey('id', { autoIncrement: true }),\n  });\n}\n\nconst db = new SqliteReflector({ filename: process.env.DB_PATH ?? 'app.db' });\ndb.reflect(User);\n\nconst rows = db.select(['id', 'email']).from('users').all();\nconsole.log(rows);","lang":"typescript","description":"Defines a User entity with auto-incrementing id and non-null email, reflects it to synchronize the database, then queries all rows.","tag":null,"tag_description":null,"last_tested":null,"results":[]},"compatibility":null}