{"_id":"waterline-sql-builder","_rev":"18-e5f2505490be2cba6fcfe045bc3097d0","name":"waterline-sql-builder","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","dist-tags":{"beta":"1.0.0-3","latest":"3.0.1"},"versions":{"1.0.0-1":{"name":"waterline-sql-builder","version":"1.0.0-1","description":"Generate SQL queries from Waterline statements.","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"eslint machines test","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql"],"author":{"name":"Cody Stoltman","email":"particlebanana@gmail.com"},"license":"MIT","dependencies":{"knex":"0.12.6","lodash":"3.10.1","waterline-utils":"^1.0.0"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","espree":"3.3.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"c26c56fba0cfdcebb0d32df1654890f5077bc272","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-1","_shasum":"c6a67fdf2e5df0365349db9b02dd530c429d9b8a","_from":".","_npmVersion":"2.15.8","_nodeVersion":"4.4.7","_npmUser":{"name":"particlebanana","email":"particlebanana@gmail.com"},"dist":{"shasum":"c6a67fdf2e5df0365349db9b02dd530c429d9b8a","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-1.tgz","integrity":"sha512-BXPgarE7r5bvnesusgWMotge5bdZKP2o+ZUV1WGGSXlv9wbVawgn4sYlU4Vxprr0K8J+3mec5HRBZO6tP07ZtA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCRSaczy+hqyHP7Ww0qHctT9WatnBIa1xP16h1gDurvpQIhAIax6DSYsZXnPB14F0wjjtNhDpnBxCX4/KQ38+Uq0/Va"}]},"maintainers":[{"name":"particlebanana","email":"particlebanana@gmail.com"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/waterline-sql-builder-1.0.0-1.tgz_1483144138547_0.8254729497712106"},"directories":{}},"1.0.0-2":{"name":"waterline-sql-builder","version":"1.0.0-2","description":"Generate SQL queries from Waterline statements.","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"eslint machines test","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql"],"author":{"name":"Cody Stoltman","email":"particlebanana@gmail.com"},"license":"MIT","dependencies":{"knex":"0.12.6","lodash":"3.10.1","waterline-utils":"^1.0.0"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","espree":"3.3.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"67b9a3e4b7f087807fd2120784fcfed394b1ba0c","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-2","_shasum":"03ea3ae02c2f3745414217c951e29e7325bcdfff","_from":".","_npmVersion":"2.15.8","_nodeVersion":"4.4.7","_npmUser":{"name":"particlebanana","email":"particlebanana@gmail.com"},"dist":{"shasum":"03ea3ae02c2f3745414217c951e29e7325bcdfff","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-2.tgz","integrity":"sha512-Cu4jE41SXyZB7TPEbI+0iY9Pn3oVBXIQQ6OEQ9L2MSk8NA+6l7HYdBFsLGGR7WUyREL4/7JInbtm7T7nILR1gg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDbkAWQzNvR88MbNyoxMd+giLLsB+7tVwOk46ILRnkEeQIhAIL7zcMuZ34ZbFZIwhaoBUyNBGFSsy6JIYw3VwszUkfC"}]},"maintainers":[{"name":"mikermcneil","email":"michael.r.mcneil@gmail.com"},{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"sgress454@treeline.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/waterline-sql-builder-1.0.0-2.tgz_1484243456181_0.5012238773051649"},"directories":{}},"1.0.0-3":{"name":"waterline-sql-builder","version":"1.0.0-3","description":"Generate SQL queries from Waterline statements.","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"eslint machines test","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql"],"author":{"name":"Cody Stoltman","email":"particlebanana@gmail.com"},"license":"MIT","dependencies":{"knex":"0.12.6","lodash":"3.10.1","waterline-utils":"^1.0.0"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","espree":"3.3.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"954135194f1aa975f7952ebef6f151175ef7191d","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-3","_shasum":"d406b6bd2c2ebcbcedde9c978c251468f1802064","_from":".","_npmVersion":"2.15.8","_nodeVersion":"4.4.7","_npmUser":{"name":"particlebanana","email":"particlebanana@gmail.com"},"dist":{"shasum":"d406b6bd2c2ebcbcedde9c978c251468f1802064","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-3.tgz","integrity":"sha512-EMIOi8/ANuobGo5gK7C6V/IzA0DLh+VsrRG+l8lmmKwDXbTi5PSBCMeQ8Ng18wr6FeaAvBZsSgTN8lhdzVTC1w==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIG8IOKyu0jYpcVz7uR2KZ7P8WvM63pRIQf7hqluTVnGaAiBzuQmHT5auxwMFaIfFsZnLAAVXLJ91CHTvbnbg/A0IXA=="}]},"maintainers":[{"name":"mikermcneil","email":"michael.r.mcneil@gmail.com"},{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"sgress454@treeline.io"}],"_npmOperationalInternal":{"host":"packages-18-east.internal.npmjs.com","tmp":"tmp/waterline-sql-builder-1.0.0-3.tgz_1485554357848_0.8697179907467216"},"directories":{}},"1.0.0-5":{"name":"waterline-sql-builder","version":"1.0.0-5","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.12.7","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"8706c7cc3d4c9883e587e8a28ffac5fd88e7f0bf","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-5","_shasum":"155434f19de62a9068ce971f17895ddb7c0d18f1","_from":".","_npmVersion":"2.14.12","_nodeVersion":"4.3.0","_npmUser":{"name":"mikermcneil","email":"michael.r.mcneil@gmail.com"},"dist":{"shasum":"155434f19de62a9068ce971f17895ddb7c0d18f1","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-5.tgz","integrity":"sha512-frqiLSHhGDWd63PBcFXIbuDZm7zcFkX1uBSM0hwsqtrR8UMfF6hJdBPeaVxMhnOv1NsCrpi/FTKkss+Dm6jyww==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCQACTk6h8PeMIsT/aGcBtfi98SLa1lhywFcOPtdUbMcgIgLOO4utBQvxPRSMZp8Aj0F4Hp+HcJg86psxYxsMVpeus="}]},"maintainers":[{"name":"mikermcneil","email":"michael.r.mcneil@gmail.com"},{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"sgress454@treeline.io"}],"_npmOperationalInternal":{"host":"packages-12-west.internal.npmjs.com","tmp":"tmp/waterline-sql-builder-1.0.0-5.tgz_1487713473772_0.9533903421834111"},"directories":{}},"1.0.0-6":{"name":"waterline-sql-builder","version":"1.0.0-6","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.12.7","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"6bcfd390f5f27b34ed60e841851fee8679885df7","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-6","_shasum":"0b10ca282c59cb917acc57861624f187501d8847","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.11.0","_npmUser":{"name":"sgress454","email":"sgress454@treeline.io"},"dist":{"shasum":"0b10ca282c59cb917acc57861624f187501d8847","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-6.tgz","integrity":"sha512-CsBqrSU4jBlg0xslgY8YpMFqSmp9xcX7K/clvWSYvFv+riDgKAkKnPCdNc30aOxf+02ertAILB0YOSfuw5UdVA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCID8V2OViAn9KMeT3UF5MuLsX7WXu5A95HJryVHpJ4rj/AiAPseRUPfCgvn7RoZiS2PvDYHZEXAitgeA2uKDdcVjLKg=="}]},"maintainers":[{"email":"npm@sailsjs.com","name":"mikermcneil"},{"email":"sgress454@treeline.io","name":"sgress454"},{"email":"particlebanana@gmail.com","name":"particlebanana"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder-1.0.0-6.tgz_1503437186487_0.7202619155868888"},"directories":{}},"1.0.0-7":{"name":"waterline-sql-builder","version":"1.0.0-7","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.12.7","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"f0bbee33ad7c86730af4326b67af8a1d4ed97a42","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0-7","_shasum":"aaabbca55a0ce90112a8602316bf23aa568afa16","_from":".","_npmVersion":"3.10.10","_nodeVersion":"6.11.0","_npmUser":{"name":"sgress454","email":"sgress454@treeline.io"},"dist":{"shasum":"aaabbca55a0ce90112a8602316bf23aa568afa16","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0-7.tgz","integrity":"sha512-X27o7Ia/wwUo05j6gyr55sEySAuY8F4OihEgx3+j3CtbRkTF8X+x7B8C+9AqWoz8qTjHS0b20S9rNIERVEwbEw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIANtFEz3Zk+YecAx7cp5cv2Vy5+y45zqeUeLUQI3PmnjAiBvghAk8c8Ne5QQ+Bo6nvRdck/ZH2Cpch3LCeHMhte2Zw=="}]},"maintainers":[{"email":"npm@sailsjs.com","name":"mikermcneil"},{"email":"sgress454@treeline.io","name":"sgress454"},{"email":"particlebanana@gmail.com","name":"particlebanana"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder-1.0.0-7.tgz_1507838526659_0.9797185368370265"},"directories":{}},"1.0.0":{"name":"waterline-sql-builder","version":"1.0.0","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.12.7","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"c0ec5f2b3f358bb706d1a1d62fd060bfeec4bd1b","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@1.0.0","_npmVersion":"5.6.0","_nodeVersion":"8.9.4","_npmUser":{"name":"mikermcneil","email":"npm@sailsjs.com"},"dist":{"integrity":"sha512-2oWLfAV5dpJHcUC3+wHoE4wjilks4kp6h0AtlgEvn3Wl8pac1MvPJmZqwRyJH2prakGfhxE+E5yBXaMQfOnUrQ==","shasum":"4bd98819bd37f5ab1df0555366e955ff56eeb8a5","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-1.0.0.tgz","fileCount":76,"unpackedSize":206842,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCRTMwR34ZJNcUSp4EUB/lYgRf9GucMhjsbk+tR/xgiUQIgS7dEwdmZgdyO2nn+VMA06yT34AVVhq7OBSV8IrXAtgE="}]},"maintainers":[{"email":"npm@sailsjs.com","name":"mikermcneil"},{"email":"particlebanana@gmail.com","name":"particlebanana"},{"email":"sgress454@treeline.io","name":"sgress454"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder_1.0.0_1522251121330_0.8718998516408385"},"_hasShrinkwrap":false},"2.0.0":{"name":"waterline-sql-builder","version":"2.0.0","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.12.7","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"17dd2e3ce2b6e20b2d22bb049135891ba0c6f4cc","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@2.0.0","_nodeVersion":"14.17.0","_npmVersion":"7.20.0","dist":{"integrity":"sha512-oeJ/LKSleTBKLo0UQZHywyWUztCqzJMy+hz+dZ0TtNfquMr7teohFzsBJmuPUKIRrWOs9F/pUBRznDdadm+YuA==","shasum":"ed4ee45fbd04a5eb0d65315e6ccefe398d0eaaa3","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-2.0.0.tgz","fileCount":76,"unpackedSize":207009,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhCZSZCRA9TVsSAnZWagAAC9oP/1nDrC80ZTa365kK3E6S\nOpVydxnD2XoTE/lPG7upxWsTBnIRoo/shWKkrbqRjsSF+AAZtmgIk3gGJ1G1\nJOBNGsjIMxdvdXS48XWp1N0ZpDyr4gXCrt4DuTIJe/eHp1hz7SOf5zv1MT6A\n/S7dw8yzEmTAAJ+WanqUb2RxAqawUkMYoI3qaxId2obp29353Whr3HOVJDhb\nEaQfvzKkUqmo23MJHy1FEhRJN4sqOlcRDomfm6ZnxWZuyRr9ulQ0cD7NsDrv\nu+ZFVpNrd/6RFQv/WAzeHZhIkh+PT+wKR2/M5JWPQKvq29ylDqv6mG+p9zVk\nV4pdfmJWAzMAMUwAD7GpLZTI8CQ0je3fNQJqu5AsStnb9V9oPWqbHrBx8hAo\n7y8HF7O8yci+gZHkArekjirOu/GVBowZZojpt8MdfM4U9Ab6Iiiw4VMztY9B\npQjXJUTC5n1FptYpkXsh1ndpOI1XY6g9G7Sm4gKTn0rm/Eqkla2BvjCItbXy\nrEeiz9JyO5p2cIdysxbMSSdCyokO1Nw+FiaAbYhmUxzHpwTVyYDVtNPShnIw\nfopVJ/n+i5vCvPUbBODcxhFfAEtnY+LBssAsyW6UxxIYTeVXzqWh9d+M7YtV\ng8m8LDSRE1nkvkhpG1BzkjwMHD4p/oxwwYIruRINRBdn+p9xWdtI5jKI9R3i\nPhoO\r\n=O0TT\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCL3b35Kn8ampDLxeSYrL91cqcUjPEyzrNuKzadv7L+swIgLSOql8p9N0wyWxXjpNIGDX5K5J1tMj6VT+HoLiDAPI4="}]},"_npmUser":{"name":"eashaw","email":"eashaw@sailsjs.com"},"directories":{},"maintainers":[{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"scottmgress@gmail.com"},{"name":"mikermcneil","email":"npm@sailsjs.com"},{"name":"eashaw","email":"eashaw@sailsjs.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder_2.0.0_1628017817229_0.40448664701659"},"_hasShrinkwrap":false},"3.0.0":{"name":"waterline-sql-builder","version":"3.0.0","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"0.21.1","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"dc07d4ef412bc4b5649146cc612dcf8747034d59","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@3.0.0","_nodeVersion":"14.17.0","_npmVersion":"7.20.0","dist":{"integrity":"sha512-HMKyggQnXtkxFYQxnJqaYMvU0M8n/lQR3XYX/ccAn7sRwnN9WzMDPRUkwipCD5hJMLAKCHXbTjWavJwS91hPhw==","shasum":"3607c2e593e55f1d450f79cb4c5d81176e56f4f6","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-3.0.0.tgz","fileCount":76,"unpackedSize":207348,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBgmHUqwDOA8fcfqCyoXwQB5nmnz7YmNpz+yH1fsDg5FAiEAozzJyktNzpsVXVkRwCF79c3OkSJtjbhSAbCOU17FlCk="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiyKSHACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmqtZA/+Mws0MkosbnnnFJUlwN08EKYuktICzeptu4m7S8qgh1Y5GVts\r\nqGztZIMBqLIL3GrmENrrj/JzEhJeuAHVwQ7PGmGKELKDG2WqmQ1ZVH4hLsmK\r\nnmMwtO+hwWcTE+s60y0q57ll2lwoniL2AYs7vcmxcRicRZ2gWECh96wnO+Ju\r\n5I8N8D8GlqjNIKfv+B4pLtB/t3kdkVgQzh7v4O5FdN7geCqkvyz+pvK1jSQQ\r\nqHjSgLhGCLKLS9VO/J4c7aYwoC1hx9q+jepchxbbr7jdTEu9VlKQscF2PFIJ\r\nALpI75/bprHhaJ0EU40eccCbUbgsi1ckikMdifyAv/L0/ZZlX01/Q9BCAZfK\r\nfXA5b42QF+8CN0H998XUnKMQRM8/PMeKJagrJfFZlwIVE7YXS57jk+nnp/zb\r\nTCY4LjCZazRX5rUa/CBYkJnG99Z7hLJcatB5n5+L5aJMe3EjMUQuxJgJ3rZP\r\n2UuqqyqsHUUOMoAAukN6WNkopoI3wMffDh55jSVj2U97ke1pG6lKRVwp92tH\r\nJFiiH6Igv/CnfY2qLo2T6VOhlB0e/rSnW9uDBXpGjMyWfufHWiSMHN/0bKuQ\r\nTTEEUPZ1xAtVMXziqB0+NLLHG8HzrQ+Vl6y5FKodETIFgFRXHgWhnGIJuhXN\r\nBmQVAEhDUhyxvbjdt8ZRash2HzxHoZz4DtA=\r\n=wBFr\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"eashaw","email":"eashaw@sailsjs.com"},"directories":{},"maintainers":[{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"scottmgress@gmail.com"},{"name":"mikermcneil","email":"npm@sailsjs.com"},{"name":"eashaw","email":"eashaw@sailsjs.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder_3.0.0_1657316486858_0.12276291847574172"},"_hasShrinkwrap":false},"3.0.1":{"name":"waterline-sql-builder","version":"3.0.1","description":"Generate SQL (stage 5 query) from a Waterline statement (stage 4 query).","scripts":{"test":"node ./node_modules/mocha/bin/mocha test/unit --recursive","fasttest":"node ./node_modules/mocha/bin/mocha test/unit --recursive","pretest":"npm run lint","lint":"node ./node_modules/eslint/bin/eslint **/*.js *.js","benchmark":"node ./node_modules/mocha/bin/mocha test/benchmarks --recursive"},"keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"author":{"name":"The Sails Company"},"contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"license":"MIT","dependencies":{"knex":"2.4.2","@sailshq/lodash":"^3.10.2","waterline-utils":"^1.3.8"},"devDependencies":{"async":"2.0.1","benchmark":"2.1.1","eslint":"3.5.0","mocha":"3.0.2"},"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"gitHead":"c86659508ec3fa52ec45aab610db9dede36b5f99","bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","_id":"waterline-sql-builder@3.0.1","_nodeVersion":"18.4.0","_npmVersion":"8.19.2","dist":{"integrity":"sha512-XW1Wf+grpm7vpxwZd5QWhYTvWEYXwlEcXPEwo3hpyMvMj9hzzQIU0smFAYIIr2AHYvMCFeu4SJmzPsahFT+S6w==","shasum":"a804759b4100bc096fe34b45533e1f52bce2ed22","tarball":"https://registry.npmjs.org/waterline-sql-builder/-/waterline-sql-builder-3.0.1.tgz","fileCount":76,"unpackedSize":207426,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIC4XUEmAbSvv5MUDJRrQrwaZwBalfwjKdLfXB68BSipxAiBVBH01pZ10GomTHRMlRlifSOmWUuku/b88xeHS8ouzpQ=="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJkGI3tACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2VmrzUQ//Zg5geEGROF3X3HxnlDQJsL0Jp1OCoTqNMweP3jffQuYieTe6\r\n75iC815rEwRqTVyi+EI7bvIlWhiCd612Et+5Lld7yrkXh23AFJDRMhagJP0f\r\nMOCzyQA7gxLhG8J8fSOK81MmYNSok2N8a5CsraoCWuJtOFnDWGltLGjJPNca\r\nIbP4HsbwgEhenTLXFyJMIaVztDz3A5ZdzvIqZdgfZjEuJ/MFPT+7ZuUi9dWO\r\n73Oz674kCwfK7Z5yZFm1kivHNLf17dE6ksuD9AqnWPpYiDNCnGSzID3WGTOC\r\nN2TG8iRITNspUlF3rhb32/zKzAwhddC7Zhk4ZBaXs4/Ih+qwHJuGtnHkAVhp\r\nA4ebGVj93msU9ldDRjayfcW9Vh2E9OGhWr5rz1BFf0KktZU0S4YVzhCF4Ibo\r\neNnKPx1XtSkP9ejzPg5ogRT3Y2jS8LtEcmkmEnqAqzaaUB5qB+C+B3gJi79R\r\neV0UkYinSk4Ll+XCCxGvYCTFbLDlcZxNar7nEPdqWPhCmSmZ/ZeHihF+1uKU\r\nw/xvB10X7ORU9uyXUYP8guczFgqgFrQpWkI3YbuRACGb7IaQx7DcmCMie0HB\r\ngZZdLYwr8ZjsJjPXjKiZHnzsIrrZ2CgTQOmDyWyncchewZATniedhh8rlJin\r\npAortLnaxlQ2u4MMQufcoSGYer8HtEqryUI=\r\n=V6ve\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"eashaw","email":"eashaw@sailsjs.com"},"directories":{},"maintainers":[{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"scottmgress@gmail.com"},{"name":"mikermcneil","email":"npm@sailsjs.com"},{"name":"eashaw","email":"eashaw@sailsjs.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/waterline-sql-builder_3.0.1_1679330797135_0.5852158212458001"},"_hasShrinkwrap":false}},"readme":"# Waterline SQL Builder\n\nBuild SQL queries (stage 5 queries) from Waterline statements (stage 4 queries).\n\n> For more information, see https://github.com/balderdashy/waterline/blob/d782be4ba5b3daefc27850e90d81b01d3709c6bc/ARCHITECTURE.md#stage-4-query.\n\n## Purpose\n\nThis is a replacement for the [Waterline-Sequel](https://github.com/balderdashy/waterline-sequel) package in newer specs of the Waterline adapter interface. It is not backwards compatible.\n\nBehind the scenes, this uses [knex](http://knexjs.org) to compile SQL queries which should be valid in any supported\ndatabase. (The core Sails/Waterline adapters for SQL databases use this library internally.)\n\n> Refer to [**Concepts > Models and ORM**](http://sailsjs.com/documentation/concepts/models-and-orm) for information on how to run queries from app-level code.\n> Or, if you are building a lower-level Node.js package, see [Waterline Query Docs](https://github.com/treelinehq/waterline-query-docs) for more information on Waterline statements (aka [stage 4 queries](https://github.com/balderdashy/waterline/blob/88bdfac31844e367a979661c4232fd5f521f3a33/ARCHITECTURE.md#stage-4-query)).\n> Keep in mind that [using Waterline statements from app-level code is _experimental_](http://sailsjs.com/documentation/reference/waterline-orm/datastores/send-statement) and should be treated accordingly.  While this package follows semver, from the perspective of application code, breaking changes could occur at any time (e.g. since this kind of usage is experimental, Waterline adapters could upgrade their `waterline-sql-builder` dependency via a major version bump)\n\n\n## Usage\n\nThis module is meant to be used by adapter authors who need to generate a query to run on a given driver. Example usage is below:\n\n```javascript\nvar SQLBuilder = require('waterline-sql-builder');\nvar compile = SQLBuilder({ dialect: 'postgres' }).generate;\n\n// Compile a statement to obtain a SQL template string and an array of bindings.\nvar report = compile({\n  select: ['id'],\n  where: {\n    firstName: 'Test',\n    lastName: 'User'\n  },\n  from: 'users'\n});\n\nconsole.log(report);\n//=>\n//{\n//  sql: 'select \"id\" from \"users\" where \"firstName\" = $1 and \"lastName\" = $2',\n//  bindings: ['Test', 'User']\n//}\n```\n\n\n## Help\n\nIf you have questions or are having trouble, click [here](http://sailsjs.com/support).\n\n\n## Bugs   [![NPM version](https://badge.fury.io/js/waterline-sql-builder.svg)](http://npmjs.com/package/waterline-sql-builder)\n\nTo report a bug, [click here](http://sailsjs.com/bugs).\n\n\n## Contributing   [![Build Status](https://travis-ci.org/treelinehq/waterline-sql-builder.svg?branch=master)](https://travis-ci.org/treelinehq/waterline-sql-builder)\n\nPlease observe the guidelines and conventions laid out in the [Sails project contribution guide](http://sailsjs.com/documentation/contributing) when opening issues or submitting pull requests.\n\n[![NPM](https://nodei.co/npm/waterline-sql-builder.png?downloads=true)](http://npmjs.com/package/waterline-sql-builder)\n\n\n## License\n\nThis package, like the [Sails framework](http://sailsjs.com), is free and open-source under the [MIT License](http://sailsjs.com/license).\n","maintainers":[{"name":"particlebanana","email":"particlebanana@gmail.com"},{"name":"sgress454","email":"scottmgress@gmail.com"},{"name":"mikermcneil","email":"npm@sailsjs.com"},{"name":"eashaw","email":"eashaw@sailsjs.com"}],"time":{"modified":"2023-03-20T16:46:37.515Z","created":"2016-12-31T00:29:00.550Z","1.0.0-1":"2016-12-31T00:29:00.550Z","1.0.0-2":"2017-01-12T17:50:58.203Z","1.0.0-3":"2017-01-27T21:59:18.459Z","1.0.0-5":"2017-02-21T21:44:35.951Z","1.0.0-6":"2017-08-22T21:26:27.666Z","1.0.0-7":"2017-10-12T20:02:07.693Z","1.0.0":"2018-03-28T15:32:01.411Z","2.0.0":"2021-08-03T19:10:17.359Z","3.0.0":"2022-07-08T21:41:27.090Z","3.0.1":"2023-03-20T16:46:37.342Z"},"homepage":"https://github.com/treelinehq/waterline-sql-builder#readme","keywords":["sql","waterline","sails","postgresql","postgres","mysql","oracle","mssql","knex"],"repository":{"type":"git","url":"git+ssh://git@github.com/treelinehq/waterline-sql-builder.git"},"author":{"name":"The Sails Company"},"bugs":{"url":"https://github.com/treelinehq/waterline-sql-builder/issues"},"license":"MIT","readmeFilename":"README.md","contributors":[{"name":"Cody Stoltman","email":"@particlebanana"}],"users":{"lucianmachado":true}}