{"_id":"@anclatechs/sql-buns","_rev":"12-031f7a0e5fc9c6ec71d3f2ffbb7a06a1","name":"@anclatechs/sql-buns","dist-tags":{"latest":"1.0.11"},"versions":{"1.0.0":{"name":"@anclatechs/sql-buns","version":"1.0.0","keywords":["sql","postgres","mysql","sqlite","node","database"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.0","maintainers":[{"name":"olamigokayphils","email":"anclatechnologies@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"da720346204645a84f8785fda886600dfa3b6716","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.0.tgz","fileCount":8,"integrity":"sha512-aw0dplj159a8+O/KuSLIUerGex+J5GjNFswTzxWmoOZ3a6nL9X5Aev/fD3Mo3LrsUgTPHRNaB325scLoUwvSTA==","signatures":[{"sig":"MEUCIAKtibU93i7SUl6gCch6RZo+489Mz6eYFROV59i++So2AiEApmgMptgfFIkkyN0gMUH70eAVMe8cg0I1PrU/jGrByx0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22038},"main":"src/dist.js","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"b0734abb79ed3f115144ee793a73d05fafd993ec","scripts":{"test":"npm run test:functions && exit 1","test:functions":"cd test && node index.js"},"_npmUser":{"name":"olamigokayphils","email":"anclatechnologies@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.0_1756898109198_0.37958493655514935","host":"s3://npm-registry-packages-npm-production"}},"1.0.1":{"name":"@anclatechs/sql-buns","version":"1.0.1","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.1","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"75184282c8c8aefddfb4ce4c88a73687041f081b","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.1.tgz","fileCount":8,"integrity":"sha512-Vz7MxKTud8PDNSWkT/Rzxax5uqi7YRjhOVwF0MNblkwtE5fCJdALfmBhK4rXLNEQBmE6IgeeZBrKYF9ajRL4XA==","signatures":[{"sig":"MEYCIQD97GXEJsqIdJBSXI4CFEopxkgprnL1reUpaXHd0vNemQIhAMI63hIwSsffkDxiZFUKazWSu+GuSiaB9b/63f2nOQeX","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22152},"main":"src/dist.js","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"030397f48d29ca804e600f8fc764c0ae9aef4e26","scripts":{"test":"npm run test:functions && exit 1","test:functions":"cd test && node index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.1_1756899402761_0.5754510207832355","host":"s3://npm-registry-packages-npm-production"}},"1.0.2":{"name":"@anclatechs/sql-buns","version":"1.0.2","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.2","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"b2c1ef5f11e2a0e32b1c64afa9224229ce44889a","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.2.tgz","fileCount":8,"integrity":"sha512-zErKRhbmozWspw++kr6Pwr7NCqlFkoyv45nwMb6+HOvRNp1Z4ETd3u1EmsJdbuxX9tOc5KjjPve1Y+LNGhHdEQ==","signatures":[{"sig":"MEUCIQDIgNpVKWhuAnnu767CDcZYoWzwlbmrU9IAAfOKdbH/egIgWUlRLEi7wbDRoYVmeiZgwHFKYtW1tSGjq3c4Tt/NdOk=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":22164},"main":"src/dist.js","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"4938cd108de8422d2c730c462f83b3b1b34debb9","scripts":{"test":"npm run test:functions && exit 1","test:functions":"cd test && node index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.2_1756899641820_0.6896733370362329","host":"s3://npm-registry-packages-npm-production"}},"1.0.3":{"name":"@anclatechs/sql-buns","version":"1.0.3","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.3","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"a904daf7c39ef9f66c1567d3202af16e969dd514","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.3.tgz","fileCount":8,"integrity":"sha512-w+HgzlQlEK1Phg3Cy52D14bv6s1y8R9vj6QO9bE5cAJ6NnQefuCfoR94irsrKcWVl2T37mzz9pjef9iliKCGUw==","signatures":[{"sig":"MEYCIQC/2puq6wk9xifkNuMNKOgQoAnpCsdG1yha8GdhyxgENgIhAJNEHvO1YXNOx/oKd61ZfKvEkWHwWuVRQcGma2HByyUO","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":23700},"main":"src/dist.js","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"7415cf3b0b22fb59e8928c6ba6c8eb091d022dd9","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.5.0","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"18.20.2","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.3_1756920624856_0.8795811438518861","host":"s3://npm-registry-packages-npm-production"}},"1.0.4":{"name":"@anclatechs/sql-buns","version":"1.0.4","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.4","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"e2dab4fb32c149fce956f049cbc92854f15ce97e","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.4.tgz","fileCount":8,"integrity":"sha512-m6f/XniJFbpV7NDkGqnSK//gj368a5I/ozYzfNf+zcTwUiM/qT3IBeBnd8J+5UZYRO4Puji+vKUr1s0mkMDjLg==","signatures":[{"sig":"MEYCIQDRMv5fmB6rM6QHKS7m5h+uL31eLhH6ke6SrPtS+SF42wIhAIjI/MfOs72WZBjNWwUcM5OHcpX60G7MP5Hk34QwXiM7","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":24467},"main":"src/dist.js","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"72ef9986f15e27d12d7fd68e53205ab12b721fb2","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.5.0","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"18.20.2","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.4_1756922323060_0.6902684632860248","host":"s3://npm-registry-packages-npm-production"}},"1.0.5":{"name":"@anclatechs/sql-buns","version":"1.0.5","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.5","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"dda2e8440807564e9c819340c4af417f8b9477a3","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.5.tgz","fileCount":9,"integrity":"sha512-S5QbSacMWShG/pE0fH3lQqTpW4k3EgzzykTX2Ss+DHavdyIZUIdqLtNc/QZ+rvHmqMGcvRIKL181fxEXuCQrKw==","signatures":[{"sig":"MEUCIDv44ajPWbeqJ+MvrdWVqIn0TE6wzJaYpnceFEgf8+D1AiEAge/WK9u3z/0Xsu6Of9P3Qbp/iA1Smytfs3x/BdL2fwA=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":25542},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"04f6e5ef7601f16d5a9fb1ba6301d25874ef27b1","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.5.0","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"18.20.2","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.5_1756923569722_0.888009845569959","host":"s3://npm-registry-packages-npm-production"}},"1.0.6":{"name":"@anclatechs/sql-buns","version":"1.0.6","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.6","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"d270041315fabd777c5c6b794c3ee49c254e22cf","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.6.tgz","fileCount":9,"integrity":"sha512-ZEtWvMDaDigdOFQhGMjiN+3oG0QZ4PNErBVWLBVGM0KBG6E7N1tHTmOu9xEoYvPy8RNTNRGzXx5GxN00ID29fg==","signatures":[{"sig":"MEUCIQC3GgHCXTIHIelPwjsX1oY+M/Yf8LZ+LM8qOFqs3VpeLQIgP09teA+28xIpOFf+PCcjdxf5TiWK+Qyh9psVZogOeK4=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":25568},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"7db93ed21d7a8465b700db56c601eab0a5f1e12a","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.5.0","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"18.20.2","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.6_1756925905536_0.8352986545541805","host":"s3://npm-registry-packages-npm-production"}},"1.0.7":{"name":"@anclatechs/sql-buns","version":"1.0.7","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.7","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"bbd025702f57e8dd98a7ec1c0e97df8af9933278","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.7.tgz","fileCount":9,"integrity":"sha512-PkiuyV96lz3uBw0dEU8f8FIKknmHSSjuOBx5hB9zFuwDrTQxg+Tou6EnGW+TGWuZdDyw1HkUwCsflK1OrpDWcA==","signatures":[{"sig":"MEYCIQCd9dsyC4j5D4akEIaViWeq3sxqSZ8PAkPZyPfxcm7JfgIhAKWMkp2eZHHfVE3VMYpOsXPPNrkvXs6T3NF4OSFfsMyq","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":35793},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"44291f81e21a73d3312518b5e975935d0698d380","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.7_1760813412593_0.06408167498489648","host":"s3://npm-registry-packages-npm-production"}},"1.0.8":{"name":"@anclatechs/sql-buns","version":"1.0.8","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.8","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"381ea7b18df1d9228c46d017b53d03d0fbfd0584","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.8.tgz","fileCount":9,"integrity":"sha512-5VgPKJ1l3eH2kUbKT/jkX65GOoJLtKHeH6sewvp5oPM3sKBstFXBKDO+W382rI2LfWT0ugCxqJ5wskFv8u/vxg==","signatures":[{"sig":"MEYCIQDX4yrk7FVl1WsocgeWG+Vb7NrSS9gDvbtJT3gztTyBXAIhAL2BAsevoSZo7qCPpYeXfaM9f/RqmjR7jcxiZle2dPig","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":35769},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"d2fe8c8dec4dd39743b2bdeca240dbaf936ddb14","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.8_1763854384650_0.09820547819974279","host":"s3://npm-registry-packages-npm-production"}},"1.0.9":{"name":"@anclatechs/sql-buns","version":"1.0.9","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.9","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"191c211cb19381b4dd4bafd196229c58a1edc781","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.9.tgz","fileCount":9,"integrity":"sha512-VZ4+7r+EtKJvPG4VUt0eNsxeRp/zJJ8Jb1a3C4menot0qFpKKtiZAdBorOYEP7Nuis1xGtBOAh2NH2it8PtPvA==","signatures":[{"sig":"MEYCIQDx8Ep30r7BZrSK8nR5suYcUfbQnrpHrpsXfJc9X3TiXgIhALWmH5RIbV6TZ+qw3PqR47wlUhHGYqpvJRmhEo9bP8MH","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":35867},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"8b3796cb15bad05164a90d6160aa9c8aa0bfcecc","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.9_1763854824171_0.6516902391013901","host":"s3://npm-registry-packages-npm-production"}},"1.0.10":{"name":"@anclatechs/sql-buns","version":"1.0.10","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"author":{"url":"AnclaTechs","name":"Ancla Technologies"},"license":"MIT","_id":"@anclatechs/sql-buns@1.0.10","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"homepage":"https://github.com/AnclaTechs/sql-buns#readme","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"dist":{"shasum":"66b270d29f6193a9e8e1d59b42d954480da35641","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.10.tgz","fileCount":9,"integrity":"sha512-Ev4OxXatr5kjuzC94jbUtZNW4Pan3NzjtRhdURW5RT4dVXcV3ykr5WY5RiQVOAEyuF4nILVlCWCrK521Gbb/eQ==","signatures":[{"sig":"MEUCIQDst8hqbqqZF+HtQkfFI0Zb6sdjIwGufejaCVoZQa1mFwIgRSKvMbpjYYmj3/X9k563X5lzAP/5QpCckifz/C9sdI0=","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":35905},"main":"src/dist.js","types":"src/dist.d.ts","engines":{"node":">=14"},"exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"gitHead":"6df50783fcc66891c1fdef4929e620ef30706033","scripts":{"test":"npm run test:functions && exit 1","test:functions":"node test/index.js"},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"repository":{"url":"git+https://github.com/AnclaTechs/sql-buns.git","type":"git"},"_npmVersion":"10.8.2","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","directories":{},"_nodeVersion":"20.19.4","dependencies":{"pg":"^8.11.5","mysql2":"^3.9.7","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"_hasShrinkwrap":false,"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_npmOperationalInternal":{"tmp":"tmp/sql-buns_1.0.10_1764628816291_0.8856149498761174","host":"s3://npm-registry-packages-npm-production"}},"1.0.11":{"name":"@anclatechs/sql-buns","version":"1.0.11","description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","main":"src/dist.js","types":"src/dist.d.ts","exports":{".":"./src/dist.js","./errors":"./src/errors.js","./functions":"./src/functions.js"},"repository":{"type":"git","url":"git+https://github.com/AnclaTechs/sql-buns.git"},"keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"scripts":{"test:functions":"node test/index.js","test":"npm run test:functions && exit 1"},"author":{"name":"Ancla Technologies","url":"AnclaTechs"},"license":"MIT","engines":{"node":">=14"},"dependencies":{"mysql2":"^3.9.7","pg":"^8.11.5","sqlite":"^5.1.1","sqlite3":"^5.1.7"},"devDependencies":{"dotenv":"^17.2.1","typescript":"^5.9.2"},"_id":"@anclatechs/sql-buns@1.0.11","gitHead":"28542571a6aaf7ce0b3e4bb2bad66b263bbc0b54","bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"homepage":"https://github.com/AnclaTechs/sql-buns#readme","_nodeVersion":"20.19.4","_npmVersion":"10.8.2","dist":{"integrity":"sha512-4huTo6VzETEaeBOtB4qlBbmAMd7FqJRvNMpGEu0ASZQhJOIyAhX7PBFSScSES5z7bMZFiRioNyxIFLjT+PAzvQ==","shasum":"236563e492948990c18ae90ceaac8d5021669329","tarball":"https://registry.npmjs.org/@anclatechs/sql-buns/-/sql-buns-1.0.11.tgz","fileCount":9,"unpackedSize":35868,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEUCIQCNM3sApRbSjzQnbFsJM+AwrzS93DffKkxiiS/Mjy4JXgIgFO2nVcNQ02d3sG0t3c0fakPUbzFBZNaqHHyEk8Ft/Wc="}]},"_npmUser":{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"},"directories":{},"maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sql-buns_1.0.11_1764685164037_0.2234964723912929"},"_hasShrinkwrap":false}},"time":{"created":"2025-09-03T11:15:09.137Z","modified":"2025-12-02T14:19:24.426Z","1.0.0":"2025-09-03T11:15:09.390Z","1.0.1":"2025-09-03T11:36:42.955Z","1.0.2":"2025-09-03T11:40:42.000Z","1.0.3":"2025-09-03T17:30:25.080Z","1.0.4":"2025-09-03T17:58:43.250Z","1.0.5":"2025-09-03T18:19:29.872Z","1.0.6":"2025-09-03T18:58:25.721Z","1.0.7":"2025-10-18T18:50:12.815Z","1.0.8":"2025-11-22T23:33:04.865Z","1.0.9":"2025-11-22T23:40:24.385Z","1.0.10":"2025-12-01T22:40:16.477Z","1.0.11":"2025-12-02T14:19:24.231Z"},"bugs":{"url":"https://github.com/AnclaTechs/sql-buns/issues"},"author":{"name":"Ancla Technologies","url":"AnclaTechs"},"license":"MIT","homepage":"https://github.com/AnclaTechs/sql-buns#readme","keywords":["sql","postgres","mysql","sqlite","node","database","anclatechs"],"repository":{"type":"git","url":"git+https://github.com/AnclaTechs/sql-buns.git"},"description":"Lightweight SQL utility for Node.js (MySQL, PostgreSQL, SQLite) with raw queries","maintainers":[{"name":"olamigokayphils","email":"olamigokayphils+gravatar@gmail.com"}],"readme":"# SQL-Buns πŸ₯―\n\nSQL-Buns is a lightweight tool built for developers who love writing raw SQL but could use a few helpers to simplify their workflow.\n\nIt's not an ORM and won't get in your way. Instead of abstracting SQL, it gives you clean, reliable utilities that act as a bridge between your code and the database.\n\nIt currently supports **PostgreSQL**, **MySQL**, and **SQLite**.\n\n
\n\n### ✨ Why SQL-Buns?\n\n- **Direct SQL First:** You're in charge of your queries.\n- **Four Sharp Tools (for now):**\n - `getSingleRow` β†’ A function that fetches exactly one row (and throws an error if it finds zero or more than one).\n - `getAllRows` β†’ A function that executes a parameterized SELECT query and returns all matching rows.\n - `createRowAndReturn` β†’ A quick way to insert a row and get the result back right away.\n - `batchTransaction` β†’ Clean utility function to executes multiple SQL commands as a single atomic transaction.\n- It provides clear errors like `RecordDoesNotExist` and `NonUniqueRecordError`.\n- **Simple Setup:** No hidden configs. Just respects your `.env` file setup.\n- **Lean and Mean:** This isn't a bloated ORM; it’s just the SQL help you need.\n\nSQL-Buns is for developers who want to keep their queries clean and avoid writing the same boilerplate code over and over.\n\n---\n\n### πŸš€ Installation\n\n```bash\nnpm install @anclatechs/sql-buns\n```\n\n### βš™οΈ Setup\n\nSQL-Buns connects to your database using environment variables.\n\nYou can use a single `DATABASE_URL` in your `.env` file or define each setting separately β€” whichever fits your workflow best.\n\n#### Option 1: Using a connection URL\n\nSupported formats:\n\n```bash\n# PostgreSQL\nDATABASE_URL=postgres://USER:PASSWORD@HOST:PORT/DBNAME\n\n# MySQL\nDATABASE_URL=mysql://USER:PASSWORD@HOST:PORT/DBNAME\n\n# SQLite\nDATABASE_URL=file:./database.sqlite\n```\n\n#### Option 2: Using individual variables\n\nIf `DATABASE_URL` is not provided, SQL-Buns falls back to these:\n\n```bash\nDATABASE_ENGINE=postgres # or mysql | sqlite\nDATABASE_HOST=localhost\nDATABASE_PORT=5432\nDATABASE_USER=myuser\nDATABASE_PASSWORD=secret\nDATABASE_NAME=mydb # or ./database.sqlite\n```\n\n#### Nota Bene:\nWhen both `DATABASE_URL` and individual configs are present, `DATABASE_URL` takes priority.\n\n---\n\n### πŸ”¨ Usage\n\n**N.B.:** Before using the library, ensure your `.env` file is initialized. This guarantees that `DATABASE_ENGINE` and your other database variables are available to SQL-Buns.\n\n##### How to Import:\n\n```javascript\nconst {\n pool,\n getAllRows,\n getSingleRow,\n createRowAndReturn,\n batchTransaction,\n RecordDoesNotExist,\n NonUniqueRecordError,\n} = require(\"@anclatechs/sql-buns\");\n```\n\nOr if you like the modular path:\n\n```javascript\nconst { getSingleRow } = require(\"@anclatechs/sql-buns/functions\");\nconst { RecordDoesNotExist } = require(\"@anclatechs/sql-buns/errors\");\n```\n\n---\n\n### Simple Pool\n\nIf you want to work directly with the underlying driver, SQL-Buns also exposes a `pool` object.\n\n- **Postgres** β†’ uses [`pg.Pool`](https://node-postgres.com/apis/pool)\n- **MySQL** β†’ uses [`mysql2/promise` pool](https://github.com/sidorares/node-mysql2#using-promise-wrapper)\n- **SQLite** β†’ supports common methods:\n `get`, `all`, `run`, `exec`, `each`, `close`\n\nYou don’t lose any power β€” all native pool methods are available.\n\n
\n\n#### PostgreSQL Example\n\n```js\nconst { pool } = require(\"@anclatechs/sql-buns\");\n\nasync function yourFunction() {\n const result = await pool.query(\"SELECT NOW()\");\n console.log(result.rows);\n}\n\nasync function yourFunctionII() {\n const connection = await pool.connect();\n try {\n await connection.query(\"BEGIN\");\n\n await connection.query(\"...\");\n await connection.query(\"...\");\n await connection.query(\"COMMIT\");\n } catch (err) {\n await connection.query(\"ROLLBACK\");\n throw err;\n } finally {\n connection.release();\n }\n}\n```\n\n---\n\n#### MySQL Example\n\n```js\nconst { pool } = require(\"@anclatechs/sql-buns\");\n\nasync function yourFunction() {\n const [rows] = await pool.query(\"SELECT NOW()\");\n console.log(rows);\n}\n\nasync function yourFunctionII() {\n const connection = await pool.getConnection();\n try {\n await connection.beginTransaction();\n\n await connection.query(\"...\");\n await connection.query(\"...\");\n await connection.commit();\n } catch (err) {\n await connection.rollback();\n throw err;\n } finally {\n connection.release();\n }\n}\n```\n\n#### SQLite Example\n\n```js\nconst { pool } = require(\"@anclatechs/sql-buns\");\n\nasync function yourFunction() {\n const row = await pool.get(\"SELECT 1 as value\");\n console.log(row.value);\n}\n```\n\n
\n\n---\n\n### Utility Functions\n\n⚑ **Tip:** This means you can use SQL-Buns helpers (`getAllRows`, `getSingleRow`, `batchTransaction`, `createRowAndReturn` etc.) when you want safety, and you can always drop down to the raw driver when you need full flexibility.\n\n```javascript\n// Load environment variables first\nrequire(\"dotenv\").config();\n\nconst {\n pool,\n getAllRows,\n getSingleRow,\n createRowAndReturn,\n RecordDoesNotExist,\n} = require(\"@anclatechs/sql-buns\");\n\n# Examples\nconst users = await getAllRows(\"SELECT * FROM users\");\n```\n\n
\n PostgreSQL Example\n\n```javascript\n...\ntry {\n // Insert and return row\n const user = await createRowAndReturn(\n \"users\",\n \"INSERT INTO users (first_name, last_name, email) VALUES ($1, $2, $3)\",\n [\"Olaronke\", \"Alice\", \"olaronke.alice@example.com\"]\n );\n\n console.log(\"Inserted user:\", user);\n\n // Fetch a single row\n const fetched = await getSingleRow(\n \"SELECT * FROM users WHERE email = $1\",\n [\"olaronke.alice@example.com\"]\n );\n\n console.log(\"Fetched user:\", fetched);\n\n } catch (err) {\n if (err instanceof RecordDoesNotExist) {\n console.error(\"User not found\");\n } else {\n console.error(\"Unexpected error:\", err);\n }\n }\n\n async function onboardNewUser() {\n const queries = [\n {\n sql: \"INSERT INTO users (name, email) VALUES ($1, $2)\",\n params: [\"Olaronke Alice\", \"ola@example.com\"],\n },\n {\n sql: \"INSERT INTO wallets (user_id, balance) VALUES ((SELECT id FROM users WHERE email = $1), $2)\",\n params: [\"ola@example.com\", 1000],\n },\n {\n sql: \"INSERT INTO logs (user_id, action) VALUES ((SELECT id FROM users WHERE email = $1), $2)\",\n params: [\"ola@example.com\", \"USER_ONBOARD\"],\n },\n {\n sql: \"INSERT INTO user_roles (user_id, role) VALUES ((SELECT id FROM users WHERE email = $1), $2)\",\n params: [\"ola@example.com\", \"basic\"],\n },\n ];\n\n const result = await batchTransaction(queries);\n if(result.success){\n // \n }else{\n // Automated rollback\n }\n}\n\nonboardNewUser();\n\n```\n\n\n
\n\n
\n MySQL or Sqlite Example\n\n\n```javascript\nconst user = await createRowAndReturn(\n \"users\",\n \"INSERT INTO users (first_name, last_name, email) VALUES (?, ?)\",\n [\"Olaronke\", \"Alice\", \"olaronke.alice@example.com\"]\n);\nconsole.log(\"Inserted user:\", user);\n\n// Fetch a single row\nconst fetched = await getSingleRow(\"SELECT * FROM users WHERE email = ?\", [\n \"olaronke.alice@example.com\",\n]);\n\n\n async function onboardNewUser() {\n const queries = [\n {\n sql: \"INSERT INTO users (name, email) VALUES (?, ?)\",\n params: [\"Olaronke Alice\", \"ola@example.com\"],\n },\n {\n sql: \"INSERT INTO wallets (user_id, balance) VALUES ((SELECT id FROM users WHERE email = ?), ?)\",\n params: [\"ola@example.com\", 1000],\n },\n {\n sql: \"INSERT INTO logs (user_id, action) VALUES ((SELECT id FROM users WHERE email = ?), ?)\",\n params: [\"ola@example.com\", \"USER_ONBOARD\"],\n },\n {\n sql: \"INSERT INTO user_roles (user_id, role) VALUES ((SELECT id FROM users WHERE email = ?), ?)\",\n params: [\"ola@example.com\", \"basic\"],\n },\n ];\n\n const result = await batchTransaction(queries);\n if(result.success){\n // \n }else{\n // Automated rollback\n }\n}\n\nonboardNewUser();\n```\n\n
\n\n\n## πŸ›£οΈ Roadmap\n\nSQL-Buns is intentionally **not an ORM** β€” it’s about giving you direct access with an extra-light utility belt. But we know some teams want more structure.\n\n- **Group transaction helper** β†’ wrap multiple SQL operations together as one atomic operation. They either all succeed or all fail. If one query breaks, nothing is saved.\n ![Completed](https://img.shields.io/badge/status-completed-green)\n\n- **Bulk insert with return** β†’ inserting one row and returning it is straightforward; this will let you insert many rows at once and get them all back in a single call.\n ![Planned](https://img.shields.io/badge/status-planned-blue)\n\n- [**Optional database modeling**](https://www.npmjs.com/package/@anclatechs/sql-buns-migrate) β†’ Defining lightweight models on top of your queries, without locking you in.\n ![Completed](https://img.shields.io/badge/status-completed-green)\n\n- [**Migrations management**](https://www.npmjs.com/package/@anclatechs/sql-buns-migrate) β†’ simple and native, so you can version and evolve your schema alongside your codebase.\n ![Completed](https://img.shields.io/badge/status-completed-green)\n\nWe’ll keep things **lean, transparent, and optional**. Nothing heavy, nothing you can’t see through.\n\n
\n\n---\n\n
\n\nπŸ“œ License\n\n[MIT](./LICENSE) β€” use it, hack it, ship it.\n\nπŸ”₯ SQL-Buns keeps you close to the metal, gives you sharp tools, and stays out of your way.\n","readmeFilename":"README.md"}