{"library":"nodebatis","type":"library","category":null,"description":"NodeBatis is a SQL-style ORM for Node.js, inspired by MyBatis on Java. It allows developers to write SQL statements in YAML files and execute them via namespaced keys. Version 2.4.2 is the latest stable release, compatible with Node >=7.6.0. It currently supports only MySQL. Key differentiators include first-class SQL support, parameter binding with :paramName, DDL support with ::ddl, SQL inheritance via {{namespace.key}}, conditional SQL fragments (if), and for-loop SQL generation for batch operations. It also offers transaction management and connection pooling. Compared to traditional ORMs like Sequelize or TypeORM, NodeBatis gives full control over SQL, avoiding ORM abstraction overhead.","language":"javascript","status":"active","version":"2.4.2","tags":["javascript","nodebatis","orm","sql","mybatis"],"last_verified":"Fri Jun 05","install":[{"cmd":"npm install nodebatis","imports":["import NodeBatis from 'nodebatis'","import path from 'path'","const nodebatis = new NodeBatis(path.resolve(__dirname, './yaml'), config)"]},{"cmd":"yarn add nodebatis","imports":[]},{"cmd":"pnpm add nodebatis","imports":[]}],"homepage":"https://github.com/PeterMu/nodebatis","github":"https://github.com/PeterMu/nodebatis","docs":null,"changelog":null,"pypi":null,"npm":"nodebatis","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}