{"_id":"5no-pg-builder","_rev":"22-6141ce396b2772eb9a2236e376d62ece","time":{"1.0.0":"2018-10-31T12:14:39.822Z","created":"2018-11-01T12:24:08.602Z","1.0.1":"2018-11-01T12:24:08.771Z","modified":"2022-04-04T10:23:20.013Z","1.0.2":"2018-11-01T12:40:32.999Z","1.0.3":"2018-12-04T19:28:32.463Z","1.0.4":"2018-12-20T19:14:01.051Z","1.0.5":"2019-03-06T10:26:21.633Z","1.0.6":"2019-04-20T12:18:21.591Z","1.0.7":"2019-05-14T18:35:43.876Z","1.0.8":"2019-05-15T20:42:52.474Z","1.0.9":"2019-07-17T14:44:00.757Z","1.1.0":"2019-08-29T10:55:07.680Z","1.1.1":"2019-10-23T10:06:36.157Z","1.1.2":"2019-10-28T06:01:49.983Z","1.1.3":"2019-11-28T07:59:11.695Z","1.1.4":"2019-11-28T08:59:49.916Z","1.1.5":"2019-11-29T19:58:40.158Z","1.1.6":"2019-11-29T20:22:39.261Z","1.1.7":"2019-11-29T20:28:39.103Z","1.1.8":"2019-11-30T13:10:42.653Z","1.1.9":"2019-11-30T19:47:49.540Z","1.2.0":"2020-01-02T12:55:58.799Z"},"name":"5no-pg-builder","dist-tags":{"latest":"1.2.0"},"versions":{"1.0.1":{"name":"5no-pg-builder","version":"1.0.1","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"ISC","homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"dae79bc0c9cb14cfb52d64d073909ecc06ba99b9","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.1","_npmVersion":"6.4.1","_nodeVersion":"8.9.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-YfF5qn4jmqQWqq1ZKfx7QoDJ5DV4rNCW7T/ZFdqJIifDb030ycc1oMoid+33BZEhXITJcca3tRNRstzSyfv4Eg==","shasum":"dad8ed300f687f966d261b667d46fb4d1dc223f5","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.1.tgz","fileCount":117,"unpackedSize":196720,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb2vBpCRA9TVsSAnZWagAAOVcQAI2JuoXqnyknnhid4gU1\nAAFjn/1QXBRKyx4Ti6OfoVeD0w++LZdSQ6X3jKcx0UDyl5SNOQGAnWCOvR5M\n2CU6bmwH5jI5WZqdnVMpPHYOUCMl/nj0/OwvdWo9WlS2PLXomg579GmpZPit\nenThrTOVWgpyBrSv4MeWEJ59s/1ovvQn7GzSAc1W142+fSo5S4FyF7w7hipc\nHOP033t6Za/84QzBdAaAY/rNhJ6RDCd/pPv7XnCfIdot+EZcPnZ9s3Dsx/GU\ni+s5z0xFJeKIX7Uj8p4ArJ0oNyHLYCgsZGysj0Neniz+OZUfPi3bAsELBOFL\nvOhbUedUaGcDprE5gBGTrDfXOWf2Fi3oLgsZhnHeZ801dVhVg5/EVG9C01N7\nGkY3Nd56U6s+Jnn18HT1kXQ2QNLWiCiKKVMIezVshMiIwjKV/ZZ5RKam82IK\nRxyCtcLqPDIUv30I7KW+Fx7Fzn+X9zEU9uJJ4KVbPARfjDMEop3QC3ckULga\nADxe61BtZjMDKG+p1Pqj0gyZolzTh3aCqN/aTp4Z5ZC702/FFSQbG36hXkKU\n9a/T7EJgN7yOaQcp1qekk8vNzIM0KgpHs3QHhQatadCnSNgemRdTaqr/St3G\nIgZIA1ATRuvD0dQjDuAAXQrADVtjzd76bCusm8WFYnT3+Q9Hh9Xk/ZMsi376\n1LFQ\r\n=O/BV\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCwWBC7JtexIg3Sm6no2KpW3IzumaIWIz0cbLjJFG3ZpgIhAMtKhuYutEA9oP2igxS/Y7Pz4cmDfqOxg5WONUegxsAb"}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.1_1541075048602_0.9654679695943857"},"_hasShrinkwrap":false},"1.0.2":{"name":"5no-pg-builder","version":"1.0.2","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"ISC","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"59ea9ff462afc53d7b2af5375bf2d4c5a9ad8b65","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.2","_npmVersion":"6.4.1","_nodeVersion":"8.9.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-Owq3b3mCG+FcmnD8FkJgybv1a41J6VqEnxzWteMJfRofUrMjo47zarBFJjVIzwleHl/0pLfyQbkg2nqIap+oXg==","shasum":"b7c4f455178044a3df07eeb690daf00e34f16793","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.2.tgz","fileCount":117,"unpackedSize":196848,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJb2vRBCRA9TVsSAnZWagAAR6IP/joPsCUvhY2R/3iiWXxB\nse+uLbtknm9lC6t/uHq4eufZ+2x3MBm4b8kTgWlF8W1VKJw3/FTAlbsZexG5\nP42OmriD38hzzECaAUTwV8HI6oO3ywn5CYNPkeSWaKOORNzvXQE4rl7qBAiv\nKgKGpEA8k+fQv/ZLEzrT3NfO6+E+Z01+oeM8S33g79jQBJkrUg03Hk+PickY\na7XuxayLaJ1QFSQx6leMbPzpEgaKIKOq5v7s35Wdx9mgGO3Y+8sYGe8JYGUb\n1c8wA5B1RdyyW5X33Oj1eDH9CIgA1TSptUMs326okeLT6aQL6n5RGkQNfIb/\nNM7bhtoqa5YeqYuwCPPY6UMRpltzvj4qlfGag+Y1IqP29Bea/HZEAs5R2eVh\nFm1Z3vrCDo6k1OYwkSWwvqzM+RmcNH6JQZUds3NqEa0ThWDfCCIps/N7KWBo\nAQluqN+OLiy1XIJaErIZueh26jN/SV25HjlL0UvStwQv4n030UUD+kt/h0SD\nMqmbbru8YwN7ScYsKOuBjFlxt9RhyFkucUaVJTsvnPIn9N8weEW0a87mXZLE\nwyfXorbSYtPdpT+tghjK0pxbJmExJSCh0b8L64I/Wf01PYyDIL7MX1zwpge8\nRMxKDxULUFYwWUbqtJFYuHpJEQPd7mp/7aZtLrGLBl6kScgGZWOGhKrvy0nO\nDL56\r\n=DgQg\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBqN+w1/XWJ1BDLjWtKvCb7i1DDNBYkLdddWUKwYREWxAiBGNGwOEZdxxDEhFzum1E/lugGHvJ2Qo2eQ94ZENOQw1Q=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.2_1541076032786_0.899779906393352"},"_hasShrinkwrap":false},"1.0.3":{"name":"5no-pg-builder","version":"1.0.3","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"b87043a7eee0fc80ba5333bdbd1818a484046630","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.3","_npmVersion":"6.4.1","_nodeVersion":"8.9.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-exoWi71TzTrHEuM4KnqYhrR4YESIjyj1qfI/6i9J7vdiIweMg4EclvV3pCZplUU/1J7N1C4B4jHBNsqV33iVOA==","shasum":"eaf80cfb7baa1c6ad1378b07599f7fb8aafd2a8e","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.3.tgz","fileCount":118,"unpackedSize":199373,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcBtVhCRA9TVsSAnZWagAAteEP/jnHHbAsLJqPd2LYgXL/\nJ6TIrXr1QMmo9fO3OITCn9iePyJvFu3OJvggVFbigpZhiSXZeFX6lLiYQ5nw\nZ9M4nSNJPqwksNTvef2f9H7DP/dQ2rC26AK8MIIsQbnit2ZMEymbitlqHu08\n+N8SWxXG+H90fVpkRD1SehzXhfle4v48CKddD5JUik9RSMD7/QVCt/yrh0Ju\nGj8e0TCiQ+hJaZfAqpUuqqAUQKZS8jJk5L9Vslpmc3RmA1iHiX1yd/FfdBB5\nELjO8UIp320Aww+a8ZTCK//CtOBrbq6NAWBzZowRL9P7LxSqW5nuqBCgA7AE\nuqerVaM7W17Z7Cdy37dX6bBM6GshVqCLvRplaSlnVfGhUkRMogNPL4IMO8GN\nRILxdY65n1jPpzjb3JifV6hTXI7PEzgUEsWsKKzJJ7m0+Fnh7i4LaqvscHL6\npAi8k2DneAbCAToVgUyrhdvELZ2oIZzc4czLTs2MQE6HEo3WrMUXol/YZsxn\nl8zKpPb8X2SEaMp3V5BQbzsvMt7AWnTtiXkJ0dNSU/bh9r9kISh0DUpVKm6S\nKl66/N1z8ryJsEWuXgXk3zOofl/Cg1xrcgkyE8eTHDdBypqveetBwnwA98Mz\nnTbez8w03K3SO+Y0x15g68aQClK13WlhYpD6w8BkUCABBhrxNf2d2ekmSe3i\nZxPt\r\n=+wtV\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDYOVNP9HbD0jvGLqJwwyLQQ5qKGcSwEfep6VzbYEMEDgIgTix90RFjXmGng2SSC3l/9RC7Wc6a5bq1EBpgP2paTmc="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.3_1543951712301_0.07730307463029296"},"_hasShrinkwrap":false},"1.0.4":{"name":"5no-pg-builder","version":"1.0.4","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"03dad2f175d3a8fb69bb728d0f592f852bb1e73e","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.4","_npmVersion":"6.4.1","_nodeVersion":"8.9.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-C8myqwdd5v+B9LMCc8sIXnqmRRY6MNN78K/dLfq86Oz/v7O9WKvsvRG+73RvEOgE5USn+wjvucVxZXqV0+rMCA==","shasum":"09170fa29effedd74ca1e42a8cb92e89637694ad","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.4.tgz","fileCount":118,"unpackedSize":199493,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcG+n5CRA9TVsSAnZWagAAGUMP/1MmJuar4OSEb+2Jm/og\n6I3RDZGDLNapxqcs7hG2NaVIfnVvdpqctLottHdA2XonthAJxJFLE/2uh6yX\nFAkBc/+xCceN2tAxI2p5s5o4itjKpIcZlTQPC1QwoaWlnWqgChfTvOho2YX6\n8uhfKYqAi+I2sjBieKLSJ1jrb65HoFMT/hwqWaMv6NYSVggHu5XfRy7O2eKb\npOnaix+cCeH6YrPT9DKPoZ7EKlzNWJvFx22tII4Pa1rlkizgpuPR0bvzuwKV\nGojOYWiX1kNu2FVNUDBA7++NuPL1Ahd5rhayug1OoUfBl4NhsUIeeXKaNk00\nn0FPUFaas0ohZMf5OPLZ5F9GsIwjQdaS7UV4TW2zXuIwhdZFymggwTplQfrZ\nshv7ijS362Vx1P19UlpJucOa2tF9+85PIg8ZDm7bPPx06ybIphfHWgg6PPFe\nNYYRASs8KuFUwH//2vIMqfsyaXOAkmCp3NN3uS+WJKbocPY4VBQ6MK6wavux\n16P/SXC/GW3PGwoo35Vqu5D9nEUg9y6qpnFT0S/21Nsz2URt8Zflow8Dq7v/\nP0mwADgG2CAAXfGR0SancuTGbCghbSJ17VYg1oAc+H9rTxKFtMNmLyaO9haw\nWZIs+9676tSUm9Mh/U1qXkqYnVoYtgMjSq9qGCh1Czo3G0lrT8X7rsdhPUPv\nxzYK\r\n=wevu\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDh40YdNFcbaRlvdcD71e7Ya8p5g18v6iyj+0ml/xZc7gIgbcEVeRhpFgRhLyAs6vhMAgqHfATvnBJdfQtZP89Df3U="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.4_1545333240911_0.7868290876697952"},"_hasShrinkwrap":false},"1.0.5":{"name":"5no-pg-builder","version":"1.0.5","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"044477b10f48cb717e381b21f2e66b0076778f1a","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.5","_npmVersion":"6.4.1","_nodeVersion":"10.11.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-E6ASA/S661RuDfOo/IfFPspA1CD6axfYZMopVkIqlpqbLodHncnhQ4nNbC4Sr/QSBm9u8XmcQ11jOgXKD4PdXQ==","shasum":"7b3a629b54f3377147eb7bf4216efd929b2704de","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.5.tgz","fileCount":118,"unpackedSize":206325,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcf6BOCRA9TVsSAnZWagAAk0YP/iBMZYHMC9y+8zWrMrBZ\nMyeIppqySjZlMzLoRdfGI3p6KL/U8cHVfzU+i9cPHk8Dr7gNfkP3SzChOpxp\nYKt9TFki1PurLjTywSDBQHh4z9snaByx9tdfs2Gbuxqm2E5T1TJRHdsvy8Lr\nyTGCoTSqmE0FsPJPNYNdzr7/k50ZZru8LcWDdUGJ0qEVmTCYJP8MIQOZiIiz\n8FqTnN4UobU+0x06jfg0I29rKA6d+r/hh2BQ+Ou6fuRw32OXESdVF4aB+xV4\nImdOXrH2q5UD6USUCg1/39e4M65JFOx74S7vt5QMikp/5wCbkm2L1dvY0bPU\n9hvoccbDBYDWeTmgVBcZojkcO+JPUFRP7twW8znY1WrnfmboP7KddDBMTZ2C\nWLILNUZmPnnuu7tP9qZ22/BDwWOfSv1tEiW4rNle1ipuO+TBmi1aylxjPJkB\n117Rn2Z040C0hPNs9/yXMJbFIuUHnKyTqp1HbLMhsEu7+w1W/7j1FY4B5/4R\nolKbjzEozw8UFgIctR78zDNc02l9XX3DLDpXG1JtAo4ggedW9KhkKnUO13a8\nSODmiEh2PDreQeQqQKApKg6nuA2NWBfOwJn+erH16QfiPm47UJdrXv8rxRRD\n05BXFqG9/JNqYqfyB456Aj384jjaq4wdy14B37QMIbnRl3uR0OPZGEMDRLUw\nHg+v\r\n=9dgu\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBQCZYQOXIqDe3PanLasfoEuVLar3IC/QDMwm0aAMvOWAiBoLtg3rj5183siLwBarKJp+ZzvwUuSp0Bu8EhdXIHXVw=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.5_1551867981414_0.8266047047634424"},"_hasShrinkwrap":false},"1.0.6":{"name":"5no-pg-builder","version":"1.0.6","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"601f2c51029f9c1cce2ab81c92c1bfbeb245de31","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.6","_npmVersion":"6.4.1","_nodeVersion":"10.11.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-E0WyL1YNomCmP6OrQz+sAmstkYK2QJuDla1xO7Nzs2QYZOvFTzi0NqmiMY2ZKdseHOGLlPlXaq/4EILS2FpKZQ==","shasum":"59ac7684cff647dad9a3871131c0758a4c72094b","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.6.tgz","fileCount":118,"unpackedSize":207613,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJcuw4OCRA9TVsSAnZWagAA1x8QAKCpVGhh1HI3t9COmlMO\nHSMBST+Q3tjvv7CEOVm9PVEkDBKVQ+AZQ/Ow7guOG5CelkfLM2ZmRF5VB3iZ\nUtdDbkyMOCbdPidMiPkupZocIWOLUCkCuZ+41Veief4Z21C/hM/ka2a+khNs\nb0wU+T9tOGIMJYPJ8db9g4haXshvccmEf51LwewBWYp3BNmboBZcYS7+RLx7\nTKLHqct1712ULKUaLTT9AtcxQ9kMascsYI1CFyxvXv2YesIXIA7K2h1LdhYb\n/PP+eMwFff4rWrhX4XZlWOhUb4/LoxKlo7uXkIlmUND5WW2HpH/cDCHkZZZi\nIfgY+lCuARSdj8VbFcUrzcaYqHYoK9jmPcmXuqDVK6iCZDjDLEJIFkUWYjok\ndvCuyCUpVHv5Lqrb22sDz+2G5Bx6vwyKnqB5OmjQ84NbB6mM2Y8YeU6UbJt5\nQqp4TO2ICIuAzTwQwxz2/zrl2ghWwUxjyBBDHv7tVb4WIL5UeTnAdznnQm3e\ngnOVEueWsG9vPKhHDYBaINNwL0EVHvN8VNakokXLLEo9hw1aXNoReso19UQS\njV0OvkYX9Wi6sUATm8nb+516vW6Dq7wKHxAPpY4v6qIG62x18QnivrmFKWxy\nePDVSvEIxExQBnlzsGUUVTb30tmy85JHTszS15gHvLSlReOdJ8ZfoFV/BiRc\ngb8+\r\n=XnK4\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIEuOUcJyfcAVIJnLb7rHVTQWgh42MSbVkeT8Z2OZH/lZAiA0Vajd2SjznXuqQntN0/MN3UZ9IzaB1Kz0bo5OEhTXMA=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.6_1555762701434_0.20293769546741913"},"_hasShrinkwrap":false},"1.0.7":{"name":"5no-pg-builder","version":"1.0.7","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"35e8f9daf49ebcb9cb00b85f24e72aad0f4d58af","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.7","_npmVersion":"6.4.1","_nodeVersion":"10.11.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-HovA7kAuZUAf4KBJxHAbiMCMvveeX8LpMScMx77TWJyJUxVRhkZJEzKY7wNho59B/1z2blw+4Czp6iy2bBDSsw==","shasum":"0f3bb6b982df3e57913346181f2f88c75ee85b48","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.7.tgz","fileCount":122,"unpackedSize":211033,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJc2wqACRA9TVsSAnZWagAA0EkP/0112DzWfyxU1c3xGGZs\nuA2T3BDZ14fH0OLvY+gBl4DeJYfJy0y9wOr6E8FDmQ5NltGR3ul5i5oImFkb\ni278UM5a/nfxqM8DN4Iq7QtDCLcX3ktU0x9YGMFWsZzUPof4IZpE0vfKN2Gt\nMdLnP1f3dasDxnqG4iy1MM0pREqI3VR0Mhr/Ik1WPniKOj0oEenvspOCn3pK\nfWPUP/UfCpUy082VcK0q1PscHfoVdjLty9udEUqnpR0NpyBrE/7tLBwmdOFf\n6b5TIIL0c+ptcZNXKt80mkkxjfQhqrNikGNYzM/+zYMGmHuoEPgk60lDnK9p\npwPpYkdpDhSCyqv9LzG13wfijJLVQcAyXW4+nPdSgtaio3n33L+QPxYPqu1m\nj8MBfFhbku0miwnPlrR9HOvZst1kKIdm4M0mrtMQBRWYZRbP4xUK4hGqLClX\n8wTlcBiIYLPMB4uHnomIAGVu0zMwmXNoHt0Fk+ItJ8NZQDgKajwINF4gE6rH\nzqLRXokgqfVQkbA24mXszCqIgrCqZNt/4tZEddcSN/ro04xvB0IqMNKUaKIF\nvnxTxfNl1IYx43E5E00IOmto80rkdBKoRadl/j6SgTnqEFI3cY4Fsc0GtnUA\nfPWpOmmrGFlEnlkLTbNvubBvE1DkMeyyx+DVz3OlElDoQdgmoDrxiTpPJgYC\nMf+2\r\n=u++e\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCEjhT9efCCO4WdX2C6JNlkouUz9vWWOys+da4NXHPtOAIgdCUvJOeHAtWQNVXUmAzo5pzv9cHsOcqji5s0FW4lv6I="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.7_1557858943772_0.7660125225884094"},"_hasShrinkwrap":false},"1.0.8":{"name":"5no-pg-builder","version":"1.0.8","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"b00b40799c1281d034ff63358debf50af396a1fe","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.8","_npmVersion":"6.4.1","_nodeVersion":"10.11.0","_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"dist":{"integrity":"sha512-E8OLWQZkFxWbf2Pt37iGUJ6FQ2npY/KqtDFM/7YDbBWAbn2pMKLFyCvUhNUWpmQOEL7OdL92JrbwbGxmrCMO+Q==","shasum":"e0d99dd964d8e7fa302c66d21b341f07c8629d28","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.8.tgz","fileCount":122,"unpackedSize":211175,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJc3HnMCRA9TVsSAnZWagAA3zcP/1AnJpadRYaP6kGG1yuQ\nxvCIw6GZD53PO7HNmTzzkHHeg79ZjBDWi3Qp11ejdYEkmoZ8X/v+KH8/ELm0\nIFDh0g3Aij/Gi4ESmnkmqVkl12qXYpAtQ5Blhv1cGdUEBsbCUNwayrd2u7Ws\nCP+jh96rxczvougQ4kki7SRdZI6dUFqOhTFs29Q2ngngyXbm0jMyDsaApx3J\nz9waoZfInBQ4nBNm2PIuCOZCqVd0AkNUbCtV0MPF58rDFQ3KOhfoXW/fECTG\nfehvT76OVGk2jB5t66tZMMsFiCI9N+n14nZ03Yj6xKy2N8dR2LsOj2wULNBr\nIV67HbvGs/YTJu/pWHJ2FnIjjkonqLIbFxhvBBDVfbZpjFgZbWjDkv1FQpbh\nbNkfcSQphyZLlqA8UcFOowPdgKa7KcHb5IKMqRekNGOZPxz5C2YFgd4XjWPs\nyHxG4RdlKfKMgIOl2dmZ35fl5bVwnGs2IJoiACN/wrGA+wtVzCyctT+SsyNR\n30+mp2TlUoUwMwqVxOMNrPG2WDD/OX4Cov2j7ncshC75iysxeINVd+LjmBK0\nHhj33t3PKXcK14kMqJPNtYNDbb80DH4sFkWNBic0GE6zFwN+SqMenqtiDDdV\nP0Q0Z2LlJOppjdejgsuUtcR0XEf4wqhL23D5n3TxRFINtu0XmbqHE8SykeSl\nrBQq\r\n=73mm\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIEx8R2BfckTv00I35tLicfzMlIFJcG2RZHkVo/MpM+GYAiEA5rYvBXV0dLdKBT6hBO38uF2MNTO0vl9kC0N3UMV8fi4="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.8_1557952972340_0.9221217737424781"},"_hasShrinkwrap":false},"1.0.9":{"name":"5no-pg-builder","version":"1.0.9","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"e34c46e901f17bc696e5d4d9f2e09786937065ed","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.0.9","_nodeVersion":"10.16.0","_npmVersion":"6.9.0","dist":{"integrity":"sha512-vDn5dbSmzR0kPN54Tm+PHyBLKJ5NcChIYT/htvu/xamTMCVfNmJ7FUKyEkjoZfUlSvbJayabdvhoD8dAN1xN+g==","shasum":"3891e72cf2f8c9f5a31055a0d173a120b60e1844","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.0.9.tgz","fileCount":121,"unpackedSize":98624,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdLzQxCRA9TVsSAnZWagAAYKsQAIXvOHKHEHugNvS4eNaJ\nwUDVzZMfON4iEhda+pmoSMGrXKngBCXB8rQovJ73bBtsTPr5ohOxoa65yosa\niJ6lo1UOrn1XAptV7a4aw0soofh6s3VnNT7Y28Cr9ac0XE8nPGYVz/im8ibW\nJxD08fd0WqIeaCC2YqZpm3ljzfS1ai+RKT+mzKDKbh2c4ISetBwy0z1L5Xmj\nS96JTofJcb2HMWtI5Hdw987MH9vGJNFzJgCZB7sElEP0Cp2KC31AJlJLAEjK\nAmr4j23km1aMR1iov126JVHXz30jmbST2aMCiUXEfBrrj4XuDACMFmp+eskp\nM+Nb70F7UhHfIlxnW7rvglp4P1S0eKDGvcpZAPfgjwZm+K3dGXZNyNONIvXg\ntDLLmgvbvDlVCkx5OWmrv0wsNbOWuRt8u2gPJCno1Xo7oJ/4qz/5Zfbq3q3u\ny8hqadlfgRHpRHj6PDKO6G518KbQeOF5c9Tp4/+wIvy2RJbwQDYvtNoR+ey3\nB4GnOJU+2vSOg7vF4PU3JIJDqLw5l+Mqa3gi+D3+L+ZcnsOA6JbbjprShzKl\nEaHU4VGNcwq2/HFHun/jLr6348fMyy/xhhQ4aV83kH3OgpLvgKvlV0mtdXxA\nCTII5YEkkwv+wOvOez3L3+bP5uBcJSptUL0VvEPESrW9Y+GB5IEpmt9dImiX\nUDfM\r\n=+pcM\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD/PwaszMc6d4r3FxTdh1TOVaereHsd7KVyIpOE0uNgBAIgE1Eg911jM4325a+ZXJwWRHEzCY00P96xYfUXUpgf4ZA="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.0.9_1563374640635_0.2580550350860322"},"_hasShrinkwrap":false},"1.1.0":{"name":"5no-pg-builder","version":"1.1.0","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"_id":"5no-pg-builder@1.1.0","dist":{"shasum":"d18fc7d4d78ef616021b5d5af037b32ec29921f7","integrity":"sha512-I+F8FPrUyvuc+bdA35s3EUbb8Mb69VVAsY/DmusqxxxrlQCo24FScm5K3uXYHz5JxRVLYBaCFAdZldVvVUUmPw==","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.0.tgz","fileCount":134,"unpackedSize":98624,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdZ68MCRA9TVsSAnZWagAAR1AQAIPv/ZQHMYlik06fnsMW\nITm0IqqdFkWfnR4Qk+vuwYG0JP1hnTARpF/+QTh1ZMW4lfpz55Fudn+Vh/d+\nobzVvrGEN93NiAWt7/2moqShd3O7FnWl7JnTFG0c7HZ6vdFc29yaseSCtU8w\njpRDEto0iEB/fx4d+I2pi6Hwz+suzdQxF7TgApx5XKD7LN0Ibmgow4wW4W+O\nCqs7HcwqXGS8kJbMZeBqbAZUOXbzIcu2aJnqsvxowtaaZLr3mK1DGbdAUSTa\n2lZ3ydnJs8ftMtAnoaQ2QT1J+FU/9mIZ6d9//sczYBYCHx6tyRMLCz8Jh9sC\nIlLqRD4j2LJRV2FCagVH1b3d+obL/Lnkjoovlsdw7VJeE4b1ZpgMXnp8AQ3L\nfnQqGPLXRi/rYLr8ZiUkSRIB9j+f3hm8LwLBDOOSI5VIhD9PXiPwqs0kZoO2\nhHDF8XVU4JnnNm8LtPAutpdUYtGCwA8kieLQevXbnk3YdvLGjSvPLtcIkyzj\nZJcJWtr6p0LcudXkKPXGHevlS2YvAEp3nU82pU2CTHuUFw5cbGlJZJwQerD1\niCzxB2s23/eYylpg1/5J/HgQLY44CLDUvZfdnRGhL6AGazAdbnclsLJ+3zjh\nyDrzRjU2QEmBqBi/cWQ6sJE+5+R2hKsYZ71i6cHSSttECNCYr3/4KvMO2QtP\nTkxU\r\n=xeTC\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHDTS74lqatFKvplh7rnAAwpPQ6mIJde93vXbsVbh8N8AiEAi+Xe7U8apfsSvkqerlUADAMmsnGjW5iTHLkSXp4hCc8="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.0_1567076107562_0.7606388295337783"},"_hasShrinkwrap":false},"1.1.1":{"name":"5no-pg-builder","version":"1.1.1","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"049a1bad3b35fe377c78bc797a83e4bd32d70374","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.1","_nodeVersion":"12.3.1","_npmVersion":"6.9.0","dist":{"integrity":"sha512-yz9EfykHRGBOefVn/RWnI+vdtbzd/9olTbSCCp95zmD1KjFYUGYo4M/k+5L6/4fvHcMHsf0Q68XSKNHpqu2MGQ==","shasum":"8ffbbf320f6c815df7eefd02cde26a6abf09456a","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.1.tgz","fileCount":123,"unpackedSize":106002,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdsCYsCRA9TVsSAnZWagAAD3sP/i2soA4VUnCHEhNuRfZg\nTNgbSONe3CPnzDQeCEP78fcUn7SL1K6vlgn0ipI6b2GiwDq2x36tfuaUvvoo\nzhY1tkJ8fIQkEZ44R3tFlH430h2UXuzGQ/hHE+KqacB5EK2wocyUBKtUDNZb\nLtgB98gjrWdjW0zdEUE25ZawJ9kq/cTaxvelaP7l4iUD25dUHwL34s2czKHn\nJyAt1f8CPFgiX3fhxpWYVZMv4s+Gr5P6yS2eXoqqWXBvfmXeF0a93wcXAOgL\nY+hI0EwerKMVHMN3lAybAJx5U/yPioiisElBW+mBv8w7z6HD9CW2xD9+URyG\nVjEPBgHixqg35cfjZpxGu0vyVvfp7FEh9EMNPLAy2jMR8rhZTmgDA4x8QhjL\nq/CzDLwj07IRt/8gy8bybVi25BBRDWhe8RHPurtCTqt6/ITLfcQ9mjzv+0i4\nAccwUmlMJbdG85ljtjl0YP6Ql1m4SxCGSSlBBnrT4Qcfs7OZw6NQsS5R1XS0\nusZOrb9hMsjImF+KMJhWbrOHQRZCB7rdsmpkmIIxVFURFviNCDijo4/Ectne\naSRl+WFD25C0BCBo/0iEJAPv5IZY6ZZ6VIBcGxp2lid++KekvsEeugpkZNXU\nM5hMZJfSp05FfrNnjW9YQcYPNegweZ+3jKAZy4fj0anUWdlJn5jPR01nrB8o\nnxv0\r\n=xWBy\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBrG3cazhOUyMpORkCy8/4tpMWeatGmeO9HtYww/0+J6AiBwqxjZXn+edq/TKm1qq7B9Aq+n4gLx3qsc/zhBDF/LQg=="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.1_1571825196024_0.2003230160668974"},"_hasShrinkwrap":false},"1.1.2":{"name":"5no-pg-builder","version":"1.1.2","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"45f47b0182db1167589aeb0a8ae6c59255db71c0","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.2","_nodeVersion":"12.3.1","_npmVersion":"6.9.0","dist":{"integrity":"sha512-gs/LzE64xoesbvJX2/OktOQDsN+m1vpGTYqxOaVk2hRd3zhat3JbxJObzf1uivB5/OoU5uxAnKFrS5yAEpw8Gg==","shasum":"424d9d2c7adf905f2dd2bd92d276e5d0715e2ffe","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.2.tgz","fileCount":123,"unpackedSize":106541,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJdtoROCRA9TVsSAnZWagAA12gQAICdHCaOEXc0k47irar5\nhSUaAffoH/IIZbCJ+mUFnqwaUxM5GnnIa1kF3d6Fz6AqWLAQiGoeccpSfrWP\nJIAgb9P/xJ8KhwHp/EHhQohU6/Qwve5hwBovpK4RCfhCEm7S8ZSACbnZ0/Ju\nK1zMmgSlURhKvUhQCnyNtT5uE3UFsSnXvr6ktz1qi0lgwZ708bPQxFqSb7BT\n40Fb8MZFrpAltCHDrmW6lRB+4szzwD4tzSj1GPS4Y80C/B8vfnIIg51nZPxn\n23Eb+J9X2TbI+us6AfJiyydpBe0FplmogjtJaeozbaMz6yc7WlHq1aUvLMMR\n/6NQlu0hoRij701PuPGu8f1D498YNYwysTusKKj/CrOI1jHmdIWiRl49gO8s\na0/ff3L+Glh29VBrZMl1bYMW3hEVOpiWqB+4T9wq1VC0diNyLvDJ4rOR5RNU\nfQ5J+5CNnJr28bE1DMXjRfjn20y6L8+9BG7DVjqz3+1cBLKqkQsEL4+EBZDE\nnopHrtcQgY8TTPVjszCZAM+dXvK2K4QIQfO4j51vwkhbd1IZ3Gf5rfzns2Dy\nELHvgpJDFiRAQmdvLZYHe454ffAObUa8WW+BZFU8Caww7/A3hS/jXsRfuXaG\nqN/Rgknhkh1/lJefyMRhXGUh1OvtLvnK4S3GAju1HhJepopafddl1JbpIY0r\nAnWi\r\n=aJY5\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDw9iKJuN7C+3FWO1lNltRNfQRTX6eG8sgTbb42g5vVmwIgGDIfzn1unAcBa9jb3rkyU1/TL50Nal5y8B38uwyAvoY="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.2_1572242509854_0.14473622391699248"},"_hasShrinkwrap":false},"1.1.3":{"name":"5no-pg-builder","version":"1.1.3","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"c47a9833e921ab34df3cd6a80fa3050f13e52056","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.3","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-vL5UwrHfj0IetlL/qtR3Pm/Ictzm/FVa1/bo2bdd/hq/OGoleAhHHwNRSTJcGT/RzmiSfeXOemo8itNfKjzw4A==","shasum":"db2a877b31b142623c5a23ba786464a57815a200","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.3.tgz","fileCount":131,"unpackedSize":113271,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd335QCRA9TVsSAnZWagAAzqcQAIh4CGOK8UYhTZShBWGt\nn13Gn/nNcLOFw8Iqqc3ihDP4Wwudqg6DRsMQfxYLStELtnL6q+KTQ8wHrqup\nt7E8kH8VwMwQIhDeLnb2HhE2ilBdWxuYKEdl4iWg1RI8jJhjMupXmEU1m+Aq\n3wC021PwMRcnkLFEkNxWjAX97Khv8nB6qcqpUTnNmuCQmCjUNfQH3jKSwuhI\nOZ7Rm+P1pEqmLeuvTwWRcmWfW7ke7btaxiYakHQIQwIhSlcUeAMOxzqd4iew\nYD0qUdvegh9SK0DT27HE+SJ9wIsZX9JiNT9n1Ab6VQ98MWGUUuZqUtR4tGvU\n7rMebi/iZ0kQ8hlSpAHeo147EC4bdoHUI3H/nQX2o0gnfm5QZ5U6ceQ9vgEs\nFRPhdThsWGrCKhFXE5wL+E3cSdKAE7+VQR7L2JRI7mi3Og4gyJjHSEnJYU1w\ne5sAMFt8mhK9FSFgNGs9srYSYXVfzJCj5yJeQGpHrElPESIDg7cgdsVVw/94\nwBIoMUOiTk3LxXypAsQiqp+647pPEYZJeIQhVqOMA3Pp7+nIFXlOtNERXgGY\nvw/zhwc/l8n2aQ9XPNsmopnom1EhTa4ymAlMnXSEqkaxvCyb4EY/pzt040rc\nFO40rqvCXeWbrcUtD3hfMASd6TcfZq0FeJHtNFlbhLtAs37Zb/iNPunNvQQf\n/dP4\r\n=e0Zs\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQC/0OPlWXBORLnQTjqLFL/JFhn2CkSLUzdudX6YUl/TFQIhAM2IVCIq5MozMrIebvLoqOUa3RRMJH3UZKz+7FJjQP+g"}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.3_1574927951504_0.065649223650464"},"_hasShrinkwrap":false},"1.1.4":{"name":"5no-pg-builder","version":"1.1.4","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"98b8959bdf4507d0c4bd4519fcd31316e5497ed5","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.4","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-h1YEt5qYKyM285KurzkMqOPCME8KZv9J8BOs4hHmYdQsGa7a78aD7JmGtbpSK7otoBJv6muCWcw+LfUqDsMWsw==","shasum":"e2c637ceedeb84a6c787c26ebe895840776e9d57","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.4.tgz","fileCount":131,"unpackedSize":113604,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd34yGCRA9TVsSAnZWagAAG4sP+gOxuNIg+yQ2Jcc/xYWZ\n3/mpFUbYbj/YnIXbYFUDb3rcYm12gg/EAfKVox6g4cleOQaB/5vfwEk9mSo3\nov3rkxo0Q6ap2vcfIBY1xlJZtZ6Wcf0n9EwNi6Y5oVpDbMlhDYJPTx9C9UNJ\n0d+B4kuT5kISawApS+Ns6pB+BTbw4wtxc1e2IX/Gah2/C/4eX6GYkH/dsbX7\nMEUgT83jtzm9siL/+wGCBNk3QYD+Oa1Rq+XiR4vnaAJf688Ihr9pHyw4eiuM\nhZGhhXoYnVDFuxwb3zj0NejFW+tXkPMDBfbRFscuXO2Ls7j6kRb/1/LxUrb5\nNBXW5Y4KJ/+t6EUC13x1Aq2bPuD+1t7o4fUB81C9WNGCeCCEtO9C/DWeX8YP\nHBnja+q3jFd+a/8Cqd6lOZQm+4Qv3NM8ZbuY8u31yD7PZFDnOiYI3T3dfRJe\nupsNfdV8rkO0dySql7m3csKGxPxDBhBRY1GQErXHegkn4+5sEy80VRIZJSgQ\nhzk1FiFUsrtYYxAQt62tgrpiyr8o3ow/g04AO0Yis/QXtO3xjtJ64Hfu39Nu\ngq7z7T8FMWNZAJxxHwBA2h9ODu3LlzxqpI7mgVkaDzkJ3QaYplTF/70clJ6h\neu+1jhCpYqhBhBkP/64u4rtCOluBkdP1BXzZ9ZO251UnYu32wm6OM92bB0mv\nfW8E\r\n=Mfjl\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQD504vNtdYnDdvPX0natTW68QcN/5LjkuFltBTiLZhukQIgGVG9xSoqyhm+nGmJQgXv3G0ITvXpI9Ug54BLL378mes="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.4_1574931589758_0.7067293718312821"},"_hasShrinkwrap":false},"1.1.5":{"name":"5no-pg-builder","version":"1.1.5","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"ade361338770be23e44d6ff0e5ee4513fb4ab449","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.5","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-WSkRl/D2/cLeu+xUzQTdm0VyRTGv7LzEMT5TMSprawbPiPYLD16qMOtBjOeEYvA3QL8/lPMR4cF0Tdtu03P47A==","shasum":"efbeeaead0d663ad90d1c649b6efa4d287549d3c","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.5.tgz","fileCount":131,"unpackedSize":113605,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd4XhwCRA9TVsSAnZWagAAPKoP/3CuFuJb8/va3wq+LaRh\ngWo2MbMArQ3jHRvXB+dkOS37uADLi08f4tyHl48xIdK6SncV9lcEE0i/Z4Dh\nSsXZsAuUU3KC8pHy151FfjRWiOwzRpnToe2gBPDdyI3aqg52l/joE/WB9SLi\nE96f3n5mSfkgLwHkNowv5OLSl3F/lXsIzWucnfEBT9d3F2YC4kUIgYPEv0MG\ndumGIVKqvJIAjaLlKwHMjoL4J2MWvmcnZ2Xx0Fm74TQBs+y4ecjnKk2qVsrB\nrME90mvDZzCLU8OWCnoNV18IEzsXWVl5Omk2z80vBWgMbK6m0EUkJXNDTjfu\nqsUiNasbsc7tLTwab5YZfjMxWKD7psNBGTUf1qXF4+N6RjwAsEVpcT8gvrAY\nfntHZZwopBNBmU9X81b1Ukz260q0fbPgEzXWadH5VDCuCkJFoBls6m3tLb0J\nA3WgrhgGQoHO8BcUsKk81jmJ39Ph4RxMCJg2IoSBYKgVw8+00+0vGbys+Quy\nPrQ5AV4Avz4COzVFb1e1rPsvf5ffE9qzGD27qK+1C3VEzoc9wiJf3QJCBHrY\nvmOKxgGdhjXRzXoN/NburaNuHPTz8kNQkv+PYSfE/jLpEzfodkaO7xwn4aI4\nZNif882qnRmNKU9qBMSIEA5k3Xeg2MlZXCUYFc/SGphdchR0U8Xja627/N4g\nIVYi\r\n=5UuY\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCPmhtNVpoReZqnP0x4Mp8kxO8FB7s5ro5W7vR2ozfaegIgXRxOTrUNxontENpMPXRThzm/FkFTGqLw8V1V2H13xvQ="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.5_1575057519999_0.3309505244278206"},"_hasShrinkwrap":false},"1.1.6":{"name":"5no-pg-builder","version":"1.1.6","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"65ad0c46925d5c7f889b3e10253c3d10afc6efe9","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.6","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-ejy8g93P5mqe+bs6njyUX3YRkXFr7ti0eWp51mOr+xNcC4XVN0rpsh4po/3VKtLnD9ztj8RuCnz9hVZPgHR1bw==","shasum":"4d2d5ba137cabfe727f8ce498e2ee53f181e2eef","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.6.tgz","fileCount":131,"unpackedSize":113980,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd4X4PCRA9TVsSAnZWagAAaSgQAID466yDhZ3doUwyMQmf\nYDoKZoZzm4LcueQhwsv/pBzNo6hh3LywQYaQIRsLlLvnvzlpMBe0Ag3cdZQ2\nveoRzd9Mx/FUxMT4NKAnRyD7IZ6SLYTRhlCJpgWXyMaWJpsS4UpEnajTn+Tn\nrxaGTuQEX0nNKyAoqFDks5u0wbmz6ZhZa689DlFbO5sLAOew9S8e22sUe1Hg\nMkg0jIhOhqXhVlOiSsWIAEVr8XkGOZhc4mmLfRVpvZLga9rKa/xs0e0n8e94\nQgy4O9f06wCQGP3FJZUszKkouGHNmVWJQEl0PpifMlqvxidBU86wcBgzUT+w\n3S9dT0kvf+NRkHBGCKPQMSTujNUPyxQ9bFTKO3XQRHTB7FxnnNjQ1ZvTXk7w\nv85e9/sg/u8F4OgSaVvUrniWMLXGmoWU8HL/lG1QNI8yhjXr0dAOPcMOO0Pp\noXflVh4L1zHZPSY0tWhpr8YHWKChbF+q9O9eKUfG3UrRZdOfjYiTJhDZ+wqL\nUIQM9EhiDms6mcdPEBsbfv3CQG+dfmdgtTkdmMwq8wYvD+p8SCJBeZ0ValB7\nIp+NhMMO0Fqh5k+6C+PPDrGvRj61egzhxT8/C2empC9545Y6xnVyy0/UNmK2\nj3bXGW+Wgm/rVrL03wgqqQag/uyP81XHkea//dPHu+qmAqENTJvPZss89QF0\nJDdj\r\n=FV9Z\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIBpMFNqL+mKBFTSSTnWRNkfqmYq4eEnkJSC6hWqmj/iFAiEAimM9H7aOA619fy/11Gu1546NbSIsz56j0jGwmluOOcQ="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.6_1575058959141_0.08181198086040431"},"_hasShrinkwrap":false},"1.1.7":{"name":"5no-pg-builder","version":"1.1.7","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"5434a07a071a0211ae7daf25fd29d8f622e32ceb","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.7","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-L///8xpgYIRPM4nbHasxlHLKcEfwL4OGjvMVEDushQ/l02KxoNsQ2LVRQ18fy/w90gKwmdEe2VlewztlKekCyQ==","shasum":"2e7297e790ef5be4c2feeaf34860ffe830917e38","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.7.tgz","fileCount":131,"unpackedSize":114164,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd4X93CRA9TVsSAnZWagAAgv4P/AkAbQSnPVtPzXbMCsWt\nCaCWhpaKEViu0PGPbYXCd/sH3JF0CRBfGF4xwy0/YwEO91Je/5l53H9FwxwU\n1PX8PauKUn1OpPgjWQbHhHdm58VdoyCaSKblqGNzTnQtsTSFq/v/vgZWdbo4\n9pWdp+P4ewoZUXumOMEV9VAJMu8PFAmwmH2ALxTFagLfHAYHZ2OOVbxL+uUE\nHZ7IA1mVaELTexxI9Gw8nGgmTF1xEiM8VYs9hlaBe0A5WSk5bi1hWX5B+Bol\npZWHYT1FSxbyNDBiB+nAfkipH+Syfr+oirbzZ9QFFqD885kYMSAVE5S4y4L4\nyTSPuw46qkvf1HyHf0llE8nQ9LbyaF5EeqwaEPwJFTvFu9YAolmGpb7GviA3\nmHDPA9oNpOXr8zqYmrTielR7YBfmDgFbREBMt1sra6Hc2nPiZ54LNEgXFYJ3\niG7OuKUzmvDMNYtJFWbjwjO6YxCpAiuKhFwbtiO+BEieVwMrrd2CdwjfVGjM\n8q5Sod/a73BE52GIuy3E6AlIoKl8Nt84bP0RAO+sQ1nZJ8KcCrQlAg5qrDJt\nm+y9iGkdoyGbbyhEKmosw37cBlg1+eJ2DywKvryLn/64UHq1YG+QUXYCjYdX\n1pZ5keFO3sPsTpRNkv5CWlCNhjA++rqcaFAdXq14oMHNBfSO41PNSbyqmFDJ\nZEkC\r\n=/vBn\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCcVYzz8WJjjRKe10mopgExXuzLJQu0zu3qhbbq0vJV1wIgLkCd3nk0a980GTPkJXk2/HEDeUIMA9hP+pLCCEtFLPw="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.7_1575059318959_0.6849395364463575"},"_hasShrinkwrap":false},"1.1.8":{"name":"5no-pg-builder","version":"1.1.8","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"8f6ee51a1dc6bf3d40c4ef457a24389e2a88b309","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.8","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-nIh3Hmb0TzpISKjSP+Sv8XoEiJX1B6mu8uKZhuP5wiW1yyMqOnWLfSh7f76MzFM8U8yBYmqqlXh0SEcc9Uvoxw==","shasum":"9be89f603ccc55ca6bd3488baf6a5aabca85aeb9","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.8.tgz","fileCount":135,"unpackedSize":120787,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd4mpTCRA9TVsSAnZWagAA/zAP/A8G69DiQUk6lmSVDjPr\ndKEqfJLhskkD20zuEfvhfVdAA8h8KucfeXgVxDT/QH5qHmsKSkUxvEqnKCEX\ncS+g0mqcR1nOhtNFyRA8ixrHnrMg6YmayV9KTWZNftTapiFu5LRydyvSlsHf\nWfFNI46vxbPnM5Igsn9EkHgoDRX6xuFLV3sgNkF1qoL+cPr9DIFEnR9eu542\nvvhXCL0tmT2yNR39v4QpbxMAqCpWeFn/ImmpDkhKVCJ/fG3SRxGAiV8XW9UV\nqBWVXnpyCvq7k3HW1yy2wO4cX88h92EUBVqISd2HEvOj6HT8/BGdmoYAFBRd\nserulv9teNhpCwJhdhHzKzO/WqxgpkfL/9iiIhD1e/caAs6xDCRt8oAq5Kh8\nUSTlNEHn3MeWf3nHFome7NH9c5KZbp+iOx11zSjY1YRfdJDq2221N9oJv3Dz\nWPEjBySRbl3xT4MwW4hMsnyRjrnnQJ6JKgJuJvRjCkYS+YBQEBWKb92b04f+\n8mR0bzomPrOEdiKKAat2YGAHe5IhmQmoaiuVnXC01SMB2/1bf9wzKzc6OKjP\n6iF4cTYDsGYxSAF4Sb1D/v7ffgwlZgvFxvMdsAccKGbNsCwe2V+9Kqwr/2sn\nBlNvvQmE9WEdUdyrc9AWuS4yLg8k5DT2GgeVuDOb3U8yxk0xhFf12nfWQbQ9\n/A3r\r\n=XucJ\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC4JB9s56VXYhEg9RL7X6Srpn/ZXDDMly7wlRROAxP1ugIgVooJzyB5HzuW5jASSAq62b8azMnnFd4KnL3EiVBN50U="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.8_1575119442541_0.8112630452895815"},"_hasShrinkwrap":false},"1.1.9":{"name":"5no-pg-builder","version":"1.1.9","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://github.com/reb2020/5no-pg-builder#readme","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"2daf9a224d0cfbcaf7db2711275dbb936a6242b6","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.1.9","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-aQz4fW89+lTZm7rxG89Vln9zhhjEzZCaNI20dS0I/fWqNBkchBnQSFawuRH1oiZTKKnK0ddTKGgS47WJHV6LfA==","shasum":"d42716457e899195e3ff8b271c51fca79cab1a88","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.1.9.tgz","fileCount":135,"unpackedSize":121751,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJd4sdlCRA9TVsSAnZWagAAlkYP/jBQLHeBbsIXK5rN0xq8\noOaJlbactjKYvDRTX1ptdWgAsPkEjeLeOr6Gu7pA4ylzXvTFhKTB7LDv8Vl5\nGe5Rv8vjpAp/styN11DpwjB9ZkuY2eaFXEuRpZddQ4aNEQEnbITaA6407QIJ\nx6QImrAIz3rjfDoZXEyK5Eosms5ScWBAezDOiJ5veJUHZIGP73mgyQjMygPP\naNW3a3W4+xD5PnPkXIHsqXtLeempNbWZ9knA04RspdtTeoVN9H1uQNmURPRx\naVop+SzvNApUEfWj63lxVpmJTt61r1IzKddza+MIwSlNTab/6gRS4grKosf8\nNfQIbg9Wnue5/JjXIqhBcrj/fYsH7SFM+rL3/tJNfHvKU/NkV6ZNu96W5qRF\nOqjTxFaBQ9jg01iXuV3822STiIJqxsZ6yZ3KuA2d8s3TbKhzGmLYkIc8/goF\nILxnHogCKrgzfTlS1L0RrTNnH+ec/4ii9yByZmCjvT1olOUoVWT4b2WZGqf4\nKBYAsG4zx46dRjOwM3yXvy0ACU8jaIxMCxZYQCh/xL1dzwre3hpGwbW9+dL7\n2PTkuBb8Cv2PZezTxI4V/mTiZ0cz3PTm4XLwRt/pbZjiEeruov/e4hK+ZUW9\n2MqiOhv3TCqMO8ygwBw91S6F7Zl8eutzhvf1e1XfCSHeVajknPNAdjRSV520\npBcD\r\n=XLzX\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDnECH/B+XiU60cIy51PIad4tvQZjpmaEU594IK/PsGuwIgSw1T44myNATJBiK5G0GYET1IQO/7Oscdg+W7RLXIAVM="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.1.9_1575143269348_0.9717513363021391"},"_hasShrinkwrap":false},"1.2.0":{"name":"5no-pg-builder","version":"1.2.0","description":"Simple query builder for PostgreSQL","main":"compiled/index.js","scripts":{"clean":"rm -rf compiled","lint":"eslint --ext .js src","lint:fix":"eslint --fix --ext .js src","test":"mocha test","build":"babel src -d compiled","release":"yarn lint && yarn clean && yarn build && yarn test"},"author":{"name":"reb2020"},"license":"MIT","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"dependencies":{"dotenv":"^6.1.0","pg":"^7.5.0","pg-pool":"^2.0.0","url":"^0.11.0"},"devDependencies":{"babel-cli":"^6.26.0","babel-core":"^6.26.0","babel-eslint":"^10.0.1","babel-preset-es2015":"^6.24.1","babel-preset-stage-0":"^6.24.1","chai":"^4.2.0","eslint":"^4.0.0","eslint-config-standard":"^11.0.0","eslint-plugin-import":"^2.8.0","eslint-plugin-node":"^7.0.1","eslint-plugin-promise":"^4.0.0","eslint-plugin-standard":"^3.0.0","mocha":"^5.2.0"},"gitHead":"9a1c596cd6cbf8f257f44cfaf414325e3d3b3ab8","bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"},"_id":"5no-pg-builder@1.2.0","_nodeVersion":"12.13.0","_npmVersion":"6.12.0","dist":{"integrity":"sha512-FswPM9+DSYU145mVWnDQlqB6+fgOuU/2BKtd36sFxNssPCZYyYP1BvVWy+FPpQUkXQqywL75O/fb2MnhYDXGqw==","shasum":"f1a8f552463c63e7e483e1eb0499a38a9ca2c30e","tarball":"https://registry.npmjs.org/5no-pg-builder/-/5no-pg-builder-1.2.0.tgz","fileCount":135,"unpackedSize":121955,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJeDehfCRA9TVsSAnZWagAAS2cP/jOMIrf3Hi40F00I9EVH\nHQ3WBFBUKEEHEKvyU3hNaapzztMfqWVLjBK/CrMrhY6zK8IGNhWw7gxfVAAd\nPOywNfFMtP64c4cp/JBGdCGUlQ/SaCZCXLiV96gh1FjY9dq/+ONU6kzBThqy\nP/o4n0OfMoxN56MODWEJrT59cNqM41G3scDdBL+jiol6brwvoapMMe6RPWA1\nUg7FPMTRu9L/XQO0I+WNzJlgXDA3qfqyQZvH7wspZ7yvRYSZtnaLxuGV0Scv\nRW0I8X8B4wO8yY+qnROSbBiaFoEvBbUqF1bJ+TZfZCqe8sDdB4YcWOFGSa2X\nl5hmkogtwAC+VpGX0dVa832RqgqXV3XnPS+AkQ9eqxuWKJTP0afbMI2yOaOi\nYIo9TpTwKYeUv/2KICeLndyXkBd3lP0hg8c7YM4Hq5cC0syw2kfnnCquFgta\nXQ3emim99qIrnAxwFKMWIjxJhi6QP2Kt4NdIwCAuiaZ41Z8vMcyhh8mpNQyc\nVo9npA+NzcblmuuAWfsH/EqbVdBK+YOrrXwrHx4cEj3nSX6MR8KPPSY/ju9e\nL5HAKNS6wV9kdaMZfc31lLgYM3Anqv2Z4xRLXbdSc64AefUMJY3NHI0jrXde\nOS2uOg+VOYaStJdNTV/nxroKKRxpZMnzbmjtiVoEPAg/c6XlMYgb/UQOK9vS\nzNzn\r\n=zeI6\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDdFR/xExFigHEEHya07qc49s9xiobG2QBlzNFPQ5feuwIgXBpnEasl/2Pp6IXNv1ehy4jAeeTLVWXKcXNvgLBKZP0="}]},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"_npmUser":{"name":"reb2020","email":"reb2020@gmail.com"},"directories":{},"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/5no-pg-builder_1.2.0_1577969758587_0.4436111130358169"},"_hasShrinkwrap":false}},"maintainers":[{"name":"reb2020","email":"reb2020@gmail.com"}],"description":"Simple query builder for PostgreSQL","homepage":"https://5no.io","repository":{"type":"git","url":"git+https://github.com/reb2020/5no-pg-builder.git"},"author":{"name":"reb2020"},"license":"MIT","readme":"# <a href='https://5no.io'><img src='https://5no.io/img/5no-small-logo.png' height='100' alt='5no Logo' aria-label='5no.io' /></a>PG Builder\n\nSimple query builder for PostgreSQL\n\nThis package has moved to [@5no/pg-builder](https://www.npmjs.com/package/@5no/pg-builder)\n\n## Install\n\n@5no/pg-builder requires Node version 8 or above.\n\n```sh\nnpm install --save @5no/pg-builder\n```\n\n## .env\n\n```js\nDATABASE_URL=postgres://test:123123@127.0.0.1:5432/testDB?ssl=false\nDATABASE_QUERY_LOG=true\n```\n\n## Manager.build\n\n```js\n{\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\",\n    rowsHandler: fn(rows, method: 'select' | 'count' | 'update' | 'delete'),\n}\n```\n\n## Methods\n\n```js\nasync execute() // Return PG result\nasync rows() // Return rows of PG result\nasync result() // Return summary of count_rows, use only with count\nasync query() // Return raw query text\n```\n\n\n## Examples\n\nSELECT\n\n```js\nconst Manager = require('@5no/pg-builder')\n\nconst Users = await Manager.build({\n    table: \"users\"\n  }).select([\"*\"]).execute()\n\n// \"SELECT users.* FROM public.users AS users\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\"\n  }).select([\"*\"]).execute()\n\n// \"SELECT Testusers.* FROM public.users AS Testusers\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"*\"])\n  .execute()\n\n// \"SELECT Testusers.* FROM custom.users AS Testusers\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"sum(email) AS sum_emails\"])\n  .execute()\n\n// \"SELECT sum(Testusers.email) AS sum_emails FROM custom.users AS Testusers\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\", \"first_name\", \"last_name AS FN\"])\n    .where('status', '=', 'active')\n    .whereIn('id', ['1', '2', '3'])\n    .whereOr('email', '=', 'test')\n    .whereOr('email', '=', 'test1')\n    .execute()\n\n// \"SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN FROM custom.users AS Testusers WHERE Testusers.status = $1 AND Testusers.id IN ($2,$3,$4) AND (Testusers.email = $5 OR Testusers.email = $6)\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\", \"first_name\", \"last_name AS FN\"])\n    .whereOr('email', '=', 'test', 'email')\n    .whereOr('email', '=', 'test1', 'email')\n    .whereOr('last_name', '=', 'last_name1', 'last_name')\n    .whereOr('last_name', '=', 'last_name2', 'last_name')\n    .execute()\n\n// \"SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN FROM custom.users AS Testusers WHERE (Testusers.email = $1 OR Testusers.email = $2) AND (Testusers.last_name = $3 OR Testusers.last_name = $4)\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\", \"first_name\", \"last_name AS FN\"])\n    .distinct()\n    .where('first_name', '=', 'first_name_test')\n    .order('email', 'ASC')\n    .order('first_name', 'DESC')\n    .limit(10, 5)\n    .execute()\n\n// \"SELECT DISTINCT Testusers.email, Testusers.first_name, Testusers.last_name AS FN FROM custom.users AS Testusers WHERE Testusers.first_name = $1 ORDER BY Testusers.email ASC, Testusers.first_name DESC LIMIT 10 OFFSET 5\"    \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\"])\n    .where('first_name', '=', 'first_name_test')\n    .group(['email'])\n    .order('email', 'ASC')\n    .having('count(email)', '>', '1')\n    .execute()\n\n// \"SELECT Testusers.email FROM custom.users AS Testusers WHERE Testusers.first_name = $1 GROUP BY Testusers.email HAVING count(Testusers.email) > $2 ORDER BY Testusers.email ASC\"   \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\"])\n    .where('first_name', '=', 'first_name_test')\n    .whereBetween('created_at', '2019-10-12', '2019-11-12')\n    .group(['email'])\n    .order('email', 'ASC')\n    .having('count(email)', '>', '1')\n    .execute()\n\n// \"SELECT Testusers.email FROM custom.users AS Testusers WHERE Testusers.first_name = $1 AND Testusers.created_at BETWEEN $2 AND $3 GROUP BY Testusers.email HAVING count(Testusers.email) > $4 ORDER BY Testusers.email ASC\"   \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\"])\n    .where('first_name', '=', 'first_name_test')\n    .whereNotBetween('created_at', '2019-10-12', '2019-11-12')\n    .group(['email'])\n    .order('email', 'ASC')\n    .having('count(email)', '>', '1')\n    .execute()\n\n// \"SELECT Testusers.email FROM custom.users AS Testusers WHERE Testusers.first_name = $1 AND Testusers.created_at NOT BETWEEN $2 AND $3 GROUP BY Testusers.email HAVING count(Testusers.email) > $4 ORDER BY Testusers.email ASC\"   \n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).count(\"email\")\n    .distinct()\n    .execute()\n\n//SELECT COUNT(DISTINCT TestUser.email) AS count_rows FROM custom.users AS TestUser        \n```\n\n\nSELECT WITH JOIN\n\n```js\n\nconst SelectQueryInfo = await Manager.build({\n    table: \"users_info\",\n    schema: \"custom\"\n  }).select()\n    .where('status', '=', 't')\n    .order('created_at', 'DESC')\n\nconst SelectQueryAddress = await Manager.build({\n    table: \"users_address\",\n    schema: \"custom\"\n  }).select([\"*\"])\n    .where('number', '=', '100')\n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\", \"first_name\", \"last_name AS FN\"])\n    .innerJoin(SelectQueryInfo, 'id', 'users_id')\n    .leftJoin(SelectQueryAddress, 'id', 'users_id')\n    .where('first_name', '=', 'first_name_test')\n    .whereIsNull('last_name')\n    .execute()\n\n//SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN, users_address.* FROM custom.users AS Testusers INNER JOIN custom.users_info AS users_info ON Testusers.id = users_info.users_id LEFT JOIN custom.users_address AS users_address ON Testusers.id = users_address.users_id WHERE Testusers.first_name = $1 AND Testusers.last_name IS NULL AND users_info.status = $2 AND users_address.number = $3 ORDER BY users_info.created_at DESC \n\n\nconst Users = await Manager.build({\n    table: \"users\",\n    alias: \"Testusers\",\n    schema: \"custom\"\n  }).select([\"email\", \"first_name\", \"last_name AS FN\"])\n    .innerJoin(SelectQueryInfo, 'id', 'users_id')\n    .leftJoin(SelectQueryAddress, 'id', 'users_id')\n    .where('id', '=', {\n      builder: SelectQueryInfo,\n      field: 'users_id'\n    })\n    .execute()\n\n//SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN, users_address.* FROM custom.users AS Testusers INNER JOIN custom.users_info AS users_info ON Testusers.id = users_info.users_id LEFT JOIN custom.users_address AS users_address ON Testusers.id = users_address.users_id WHERE Testusers.id = users_info.users_id AND users_info.status = $1 AND users_address.number = $2 ORDER BY users_info.created_at DESC     \n```\n\n\nINSERT\n\n```js\nconst data = {\n  email: 'test@test.com',\n  first_name: 'Test',\n  last_name: null\n}\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).insert(data)\n  .returning()\n  .execute()\n\n//INSERT INTO custom.user AS user (email, first_name, last_name) VALUES ($1, $2, NULL) RETURNING user.*\n\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).insert(data)\n  .onConflict(['email'])\n  .doNothing()\n  .returning()\n  .execute()\n\n//INSERT INTO custom.user AS user (email, first_name, last_name) VALUES ($1, $2, NULL) ON CONFLICT (email) DO NOTHING RETURNING user.*\n\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).insert(data)\n  .onConflict(['email'])\n  .doUpdate(['email', 'first_name', 'last_name'])\n  .returning()\n  .execute()\n\n//INSERT INTO custom.user AS user (email, first_name, last_name) VALUES ($1, $2, NULL) ON CONFLICT (email) DO UPDATE SET email = $2, first_name = $3, last_name = NULL WHERE user.email = $2 RETURNING user.*\n```\n\nUPDATE\n\n```js\nconst data = {\n  email: 'test1@test.com',\n  first_name: 'Test1',\n  last_name: null\n}\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).update(data)\n  .where(\"id\", \"=\", \"123\")\n  .execute()\n\n//UPDATE custom.users AS users SET email = $1, first_name = $2, last_name = NULL WHERE users.id = $3\n```\n\n\nUPDATE WITH JOIN\n\n```js\nconst data = {\n    email: 'test@test.a.a',\n    first_name: {\n      builder: SelectQueryInfo,\n      field: 'users_id',\n    }\n}\n\nconst SelectQuery = Manager.build({\n      table: \"user\",\n      alias: \"TestUser\",\n      schema: \"custom\"\n  }).update(data)\n    .innerJoin(SelectQueryInfo, 'id', 'users_id')\n    .where(\"id\", \"=\", \"123\")\n    .returning(['email'])\n    .execute()\n\n//UPDATE custom.user AS TestUser SET email = $1, first_name = users_info.users_id FROM custom.users_info AS users_info WHERE TestUser.id = $2 AND TestUser.id = users_info.users_id RETURNING TestUser.email    \n```\n\nDELETE\n\n```js\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).delete()\n  .where(\"id\", \"=\", \"123\")\n  .execute()\n  \n//DELETE FROM custom.users AS users WHERE users.id = $1\n```\n\nDELETE WITH JOIN\n\n```js\n\nconst Users = await Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).delete()\n  .join(SelectQueryInfo, 'id', 'users_id')\n  .where(\"id\", \"=\", \"123\")\n  .execute()\n  \n//DELETE FROM custom.users AS users USING custom.users_info AS users_info WHERE users.id = $1 AND TestUser.id = users_info.users_id\n```\n\nTRANSACTION\n\n```js\n\nawait Manager.begin()\n\nawait Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).delete()\n  .where(\"id\", \"=\", \"1233\")\n  .execute()\n\nawait Manager.build({\n    table: \"users\",\n    schema: \"custom\"\n  }).delete()\n  .where(\"id\", \"=\", \"1234\")\n  .execute()  \n\nawait Manager.commit() // or await Manager.rollback()\n```\n\n\nRAW QUERY\n\n```js\nconst Manager = require('@5no/pg-builder')\n\nconst SelectQueryInfo = await Manager.query(\"SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN, users_address.* FROM custom.users AS Testusers INNER JOIN custom.users_info AS users_info ON Testusers.id = users_info.users_id LEFT JOIN custom.users_address AS users_address ON Testusers.id = users_address.users_id WHERE Testusers.first_name = $1 AND users_info.status = $2 AND users_address.number = $3 ORDER BY users_info.created_at DESC\", [\n  \"one\",\n  \"two\",\n  \"three\"\n])\n\n//SELECT Testusers.email, Testusers.first_name, Testusers.last_name AS FN, users_address.* FROM custom.users AS Testusers INNER JOIN custom.users_info AS users_info ON Testusers.id = users_info.users_id LEFT JOIN custom.users_address AS users_address ON Testusers.id = users_address.users_id WHERE Testusers.first_name = $1 AND users_info.status = $2 AND users_address.number = $3 ORDER BY users_info.created_at DESC \n```\n\n## License\n\nMIT Licensed, Copyright (c) 2018 Aleksandr Sokol","readmeFilename":"README.md","keywords":["postgresql","sql","query","builder","parameter","param","parameterized"],"bugs":{"url":"https://github.com/reb2020/5no-pg-builder/issues"}}