{"_id":"sql-query","_rev":"132-80afce5206df7d7f0b4ee59ba3434423","name":"sql-query","dist-tags":{"latest":"0.1.29"},"versions":{"0.0.1":{"name":"sql-query","version":"0.0.1","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.1","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"31fdbf8e965e1783aa8f5d9ec0d5be6d33d0140f","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.1.tgz","integrity":"sha512-dE3F7YLyqDN+4TN3w1U//TT85UKROg4/iB8Az2L1R/KidYXP40Ou7jQKwuwvcU8VebPmFL3xJXYu4ZLDZmGnvg==","signatures":[{"sig":"MEYCIQDmURW76CODDy9Zd4FPF66XsPVRWfAYMLkoMD5wjxRj8QIhAI1MVsYjPypYDk/+FX+K8+tZ3zEPgAvfR1JVpj5507i3","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.11","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.2":{"name":"sql-query","version":"0.0.2","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.2","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"769da6fb81eaad31887fa93306f4b6f2ee6ad746","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.2.tgz","integrity":"sha512-k/yFyp6UmkgMLcGsCDrta+8Zn6w9knhuJjkvZztVUoMZ5bZswzf0b0Ye3y+bhMlK2hIF+03kyegUvIzce/0Lrw==","signatures":[{"sig":"MEUCIFfW0Wd1RmsCVPvOPiDg2Dajmy3PGmzGbtapsonlp1WVAiEAv+iNd1pV3oBw6I1dKii67XXXuFBYia+coM23/ayva9k=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.11","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.3":{"name":"sql-query","version":"0.0.3","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.3","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"ee0434131673494cb8607cbcf2c9286af44dc5ad","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.3.tgz","integrity":"sha512-U1xvDHNOgSa4rSy5jf/ixsb7K1C9M7KfoWjYainBW7KhPqujpEiujQ3YmBXlmOGy+s/penoH8QooqEcHji6Vtw==","signatures":[{"sig":"MEYCIQDezTIf1O05lQaith3/hBhvDOEsuTpT2Z2D8YIDeFDMNgIhALYA9tuMIFRhEiFO3E/I7GW02JQboi15nvzIkKsptSbV","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.4":{"name":"sql-query","version":"0.0.4","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.4","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"e2253cab1351a0932647c521075c536aff9861bd","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.4.tgz","integrity":"sha512-x0T7yf3ffpzZnFb9u9pW4EDOgzxupVNffrqIsiTFa99jVRkkGXrC3k++7bFTuQNdxk+wcxIisbP9U/uEtT4e3g==","signatures":[{"sig":"MEUCIQDo3FJ380L/Zp/LSckhXR8NOzg/v8YB9DDbpSkZxH9isAIgGRaJEQq2zOLpurhzonCCihy7MnTOLDGOQyxJsf//zrs=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.5":{"name":"sql-query","version":"0.0.5","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.5","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"b41480d4ffb15e9cc66076f5d0e49dadcbfb7e93","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.5.tgz","integrity":"sha512-PbS74s6j6LAYVVLeFPrM/SWGjtvk6LkegqfxwK4X4cXsySzncnD/EpaA3U4JrTqdQchn9iBTcB4gz41wev5Zog==","signatures":[{"sig":"MEYCIQDH7GrhO74s77k3tOQfhakQdRvlOCAYohhWzOTsSe5PTgIhAKaKcxs6hImjovEh0ftYxmf+fIgqMHjOLvGenNwV2F17","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.6":{"name":"sql-query","version":"0.0.6","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.6","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"665ebb0bd8b1455828ba58f0c867870421c9a2f3","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.6.tgz","integrity":"sha512-6sEuj7asEMxtN6Vvr2a+w+2+H5SWydQpu6ySjqRoS6QNmbyk/Na4cKWOeGQRcFNFNjHrqtSwQtVGRU2oYu+xGQ==","signatures":[{"sig":"MEYCIQCg6ABwDxXf/bMgaOqfzqIpaLnVjwj4GFHKXXM7j3G21wIhAJqNvZKtIg2IPPZY69wRx2TyTCF1UaDyMHwX4efnK1fX","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.7":{"name":"sql-query","version":"0.0.7","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.7","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"e2fdafb83cc9da39636deed44ea8602560b4b9bd","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.7.tgz","integrity":"sha512-9GCRsOF0eZRikKhXFxZlCn6qY1t7MsSRXWGZYw9Szufl9/jfq6hVlWN9Ww54/bsp8pQLzSO1YmjlFRfkW4r4Gg==","signatures":[{"sig":"MEUCIQCMFxXSakYSXzdIZcBUqvdJPYDYPMyfgtK8GsdCVpL2QgIgXfm4qou3Ssr7iMhR4PdQL81UeJUaFzfys1UxepvLPNo=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.8":{"name":"sql-query","version":"0.0.8","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.8","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"2e0d0b71bb7f38e14cf75113cd5ddcd4491f0d6f","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.8.tgz","integrity":"sha512-Ak9wzc4IkaZF7lFsoTQmB8WH1HmlKOoQqzwa9W5MTixNhuTMXkAB25EMMLSa0qIgX/8mSv4AA3ZTB3ZYFM28NQ==","signatures":[{"sig":"MEUCIQC85YX1vacNz1sPfK22LFSQlKR1qXHcs98lDxCHXBpgkwIgY5NIi6bakfLpnwBf+J3k6Bch0Ss3dwMCkryZCvDU56M=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.9":{"name":"sql-query","version":"0.0.9","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.9","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"94b6f7d79ab363016d322552576da0a49ff5d260","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.9.tgz","integrity":"sha512-a6wnxg+a3+jvTQ2vZTOBia1JAVpIIZZs2JZSlbvMKvqC+DeR2IxmCbzbJQUCAQHXZLdSpt+MQObijMvwy0faxg==","signatures":[{"sig":"MEYCIQD6Q/yeV1CJzvIzGDE53yyvfVZeO+LSAH0iq5JCRaRCkwIhAJMB13yX6TqaWRWyvBUIIptCuHumVpUf8V8Kdxfi+NlH","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.10":{"name":"sql-query","version":"0.0.10","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.10","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"5c43cab7d0b317b03153249fe65efd36bc43a450","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.10.tgz","integrity":"sha512-UEVkpHytXRicyXXiClga7dcteQH5HfsRAaAWENcXEq2/dkfisO48453j+Ogj8iENqoE3/yxb2C1F4eUvG+eFSA==","signatures":[{"sig":"MEQCIBiQlkSHGkUbWg4tFcTn4HE6GABhwHAeOAK2tCurWjxAAiAvUdrojkCZd89fIZ0F4ShDCcib5A7AanmJxZvSq8l7ug==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.11":{"name":"sql-query","version":"0.0.11","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.11","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"fb8d5c702122ea96e171fbdda0ef671a4437370c","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.11.tgz","integrity":"sha512-8M4MQ7gHj4M5IK7lDDSWA1pi1Z8D9qLmhoRZVKqLqX8fxKb12OsWAUtvWfKKUqd0PDbcm3vj9P5lsVf9/8L1fQ==","signatures":[{"sig":"MEUCIQDMFdFFUDMibHFMgFQvRqhkgdDYOkpDs/FcTZGIMRUZtAIgE/s09f1qqxmfuSLIUoaKgXsPyDsiFGTXfa4emuGSI+A=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.12":{"name":"sql-query","version":"0.0.12","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.12","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"372e410ac06c770d3e38178da11ef02c6db37dfd","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.12.tgz","integrity":"sha512-W4S/Vh2wUMNBK8RlfCDXAPiYnIa/TGWcBFAM/kgx2mNQqVtvmL1xIKSiZJhS8JH5KTBIhe7KU5x1N3NmwVbeSw==","signatures":[{"sig":"MEQCIBCCcld1EsTcvl6kFkLcucFXaTglKRZ3bjLXhCrdLtLeAiAcTKmN0e6FWqDHsc21CVKkDNw8PG6lWfiwWZBhHQlGLg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.13":{"name":"sql-query","version":"0.0.13","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.13","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"a418a8aa2431f0f560ff19e1d3b6bd74e9c95455","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.13.tgz","integrity":"sha512-ZUDVGduNIsbZxEheXzPcW0ShNPdxYE/eLF0IwWWNGVsuVIUGvA5RS9j0rWSWqOs9J3EIRk/9JwOwdLHKK0sV2Q==","signatures":[{"sig":"MEQCIGJnU8vs22V0zKbqjixH4YCI2tDZcCiRLC8xJHJJC/q0AiAEBLCUol2yzMGtpoYP9RpEXJEaCDb/cxgrQkDnZr8mSQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.14":{"name":"sql-query","version":"0.0.14","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.14","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"5f7100b336fa9cc2399a116c1af163571cf7f858","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.14.tgz","integrity":"sha512-1RHSlgNbl09iZZpIzpolfUrZ+Me9Cl/WuFyrnBv69NutscnJQOFIDdrBY1B84Quo5gprTsM5+kHS8wKRXt3TpQ==","signatures":[{"sig":"MEQCIEChbDcJuZWtmxgEywxD6hdLFqLtw3a28mCUmcWj25KmAiBtA5hEGR5azhAexXJfMijYJr4iesK/scdRTOEKk0jwbQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.15":{"name":"sql-query","version":"0.0.15","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.15","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"fe7a0054d15cf3d482353680059d01d10dc74801","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.15.tgz","integrity":"sha512-ntBCf6LXSXORhkA0+oA097UkFdLE9xn19LX6jBtNWRTOXqs9rrk7SvARpmjFk3zYPCn6J/EKt4NR8ePPdsXpjA==","signatures":[{"sig":"MEYCIQD/prRdM3a2zZ+H5JMhVLTutKVQsWtulOX1w1/MKqrTMgIhAPTtJfAd/vwbA8/p6mKoNciz1cOQlzkhwpjz2b7lmJ/Z","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.17":{"name":"sql-query","version":"0.0.17","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.17","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"6de3ad78e153ac29ebbb63675728252309ead341","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.17.tgz","integrity":"sha512-ft9sRrCozvXlGekhsKVbEGeJcPDMhWRqJ8+DdFYaXQ4zy55Sn0yFwj8blkNweWF9eu9gpzyJS6Ws4kK/rr3sWQ==","signatures":[{"sig":"MEUCIQDPuj+E2/AKCARH0Tt49Op1L50xZJ2y7IMPESF2M9B14wIgMbmweQ6fvl8nIqdGYc8yJ9UqZKvxIgViS2PZKvyLg8c=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.18":{"name":"sql-query","version":"0.0.18","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.18","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"470aad84aeebef3d5fe147a92382b751da1a364d","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.18.tgz","integrity":"sha512-HGyQXgPDsNAZMDq+IwBGtYCQLSM8O7KIoste2aNcmyDXS8XAEtNeXnJtxt/6uvEHvsjOeoEIvj11DlVP4/+l8A==","signatures":[{"sig":"MEUCICaFK+RWs1LurOEcNWktBlX1YPIbQgF1+BX0mUxIfF3+AiEAj2sW7jbjyjknBmmTTVvrc6yyQCE4zdDN6XuZaTRdMRw=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.19":{"name":"sql-query","version":"0.0.19","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.19","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"0674176a43f85a5ff33fd58b09d7527b273e3eeb","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.19.tgz","integrity":"sha512-2PyjUsCpY9A+uwm4AivJqndgsnyHfN4crPCMVkqu2GqzdAM/3BERHpHa7FPHwCiyYfLw1TCuBxiXBHwQHaYcQA==","signatures":[{"sig":"MEUCIHVrTP7YfoUGAhKw5O3cyGLU8k8nUIb44AJQBnlo5tB6AiEA8qnjmaFTcVlA8bX1YABguN9mhDTSfmQ1oypnaEOvdlw=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.20":{"name":"sql-query","version":"0.0.20","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.20","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"f6611b8c69578c43c970990cd3d40e01e5f2a1f2","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.20.tgz","integrity":"sha512-ruEsq23szSfkaDKmosjZDfXx+36W+1PlorlE5I/KE3R6rrA2Yx4a0CBl7WM3gf8CMvK2wobC5lLK3XsUD8JdYw==","signatures":[{"sig":"MEYCIQDW3CeMNk1WGd+neHuRSlnwT3Kv2YbsAaAuNYwEgsX14wIhAJ2HO6aqcbqsHPJeuQgsnv6Sk2HLruhQzSbYEBbqzSkn","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.21":{"name":"sql-query","version":"0.0.21","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.21","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"6990f79f9c4326266f1d891678b114551545996a","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.21.tgz","integrity":"sha512-IPmHr+xHGKTxiaAp69lJmEhR7n1rHmQQIxJ4+VaO3UpX7iYI5VieONecGsw5kEhs5Bcu6iFaC/KpY8fid2P5KQ==","signatures":[{"sig":"MEYCIQDeb0Ps2/tZoLYb8hVDf4Ojf7dg9/YJtP6UhqEiFgacBQIhAMf6FwT6vI/XOu03umZa7m88h9/zTumjPBE2WGwfg4Gk","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.22":{"name":"sql-query","version":"0.0.22","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.22","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"ec24ff6b93b6ad9f0f940dbd6a210d1b4b0c4314","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.22.tgz","integrity":"sha512-RjOYfZN4VqMIc0Ib5OOObTf+ECimhfwG1iWu6kWb27HTOJw/fm8UpSBjb8D48NBwvDTVlImhWV5LMJYSr2L/Vw==","signatures":[{"sig":"MEYCIQDm+CMlZFXmQjR2jeNKzfSuncMxAzN4hP/6QdexH3ZQmwIhAL1KM0kKZVK9TK+ElMOE3ANRPQbUPE4LCy/FpOY5aafy","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.23":{"name":"sql-query","version":"0.0.23","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.23","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"90fdc932e62589e59768609b9760ff832611e96e","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.23.tgz","integrity":"sha512-xyRFPXKAaCSAkhPK2aggd06wBBckFSEz98cOnAohHBH5t0D50o8L8W8n8f2XwKviZ7ILhKtjVfsd+QP+slACqA==","signatures":[{"sig":"MEYCIQDOgw8ukv8wGCWWEEBuU2PaQlt9q58aJv/TK+Vy529r+gIhAJvnb+faU5q9nC6OK7psMVGXHvhXFIejw8SXRk3D3vWX","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.24":{"name":"sql-query","version":"0.0.24","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.24","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"7934ecc238ddb3804c437f09d5bee12e8c77afdc","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.24.tgz","integrity":"sha512-O7T0dvxdpGfTESYOHFJttyh0DBEbV6V38/xDYTOf0QddCsXh2T98+Ir7uQ72VSWaEWjjN1xsQllt8fROvv/dGw==","signatures":[{"sig":"MEUCIHtkeE9iiOyA7XObI+3ZYdO0oKUs4GF5CypyvotIzaYuAiEA9AobJtMD3JuCsvILzB0KVGoMHcUlYGXMaVsJxhsZqoM=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.25":{"name":"sql-query","version":"0.0.25","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.25","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"82c94057290008be76e377be81834ca9abf77d25","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.25.tgz","integrity":"sha512-9u/u3pHfYJBqu2l94bTu2qph1uaoeYIAQ0qzj11vbm+Cy+nqwPXz/Rx4nB0HJxcBawDQ7Na3r6n+mzXpF32DQA==","signatures":[{"sig":"MEUCIADCLWGDsIyx7oky28W/gPM3E3baZwvnujOsOAnDsfICAiEAupVSVPzB1r79JoHrlvFqfzkvZgPK1V5SfoMSFEIycxY=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.26":{"name":"sql-query","version":"0.0.26","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.26","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"dist":{"shasum":"7916c88bef5c69b2df0d8bb2e6bc65fae287e9cf","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.26.tgz","integrity":"sha512-j04Pps2uGD6+KTD42XVlu3y72etGpoV2k2UPQBaocOyCgLK7mNCpxE1r5pEQxXEfaOJnJ7czkdRXsTJkd9UHJw==","signatures":[{"sig":"MEUCIQCkfYf+h+wTnqpMThL0W5QOrtna3lyCU4eQJRPSZ4hxGAIgfLNOju+M8Xz4tzXM+ZCIgf1XqeskU/mpibi3vPZiBUQ=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.18","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.27":{"name":"sql-query","version":"0.0.27","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.27","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"d69ba61ed1ff0ba2e33f8532a71df0afe124de14","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.27.tgz","integrity":"sha512-0xWtZj+2grXR/2vrT9+5CUiBju2yuquxY+H3C1OXfCQbAD444CQHgXDBuMgbbBWGoTxz2etkWwsMQPOp6EFhwQ==","signatures":[{"sig":"MEQCIBvkZwVSz7m5WXjPFkkjMinJ19oHgixClSK6karwklINAiBK4ZIpSjtA1iJHFXKf+KXJT1DnfM1L1VowUIYxbV6ICw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.28":{"name":"sql-query","version":"0.0.28","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.28","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"166c3242892709d75f2a758486971826ed179163","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.28.tgz","integrity":"sha512-OHSkEz5km/fym6psznFob8keTXb0KPfD9FQDcYbCeKOrerZCPgh1a199wE1zibdA5s7TNtXlGeBU77qQReo3hg==","signatures":[{"sig":"MEQCIH4eBiQ6GYMTIX/ncJpUh2pLWit4RN8cYpk+llcmnlMgAiBbYt1o3mp44JsdP+6qdW5OwONadrgcbXE6vx1WgD6mOQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.32","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.0.29":{"name":"sql-query","version":"0.0.29","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.0.29","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"8468c2c72a8643b148fd0849c98096237c4f9e46","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.0.29.tgz","integrity":"sha512-cM8lj5fivClnLh/cRNhNJPMk8/mYhRKTUDsSP6L/m1lM2EX4rxaKxRNf96izhsu9i8upLKYNBzFk/+jWLnWgTw==","signatures":[{"sig":"MEYCIQChlMaIuqxjgr+hK7yFN343RKaoZVIwyEOcAxZT1uuW9wIhAOBL6rKFdC2mwQOFkFSzPsjtMiw8wrRRyzc6nJMPv3hK","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.0":{"name":"sql-query","version":"0.1.0","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.0","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"45ed857f31c37b1089930411ede1549bbb29096b","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.0.tgz","integrity":"sha512-UU+LQ2Xej8uOApp53fBoxwTUsfNZ+Y5VZuKuTa44zDsAk7FnsMCUN00fm0FgtY/WNJ99qAL7PnjMTfAQ088EJw==","signatures":[{"sig":"MEQCIAbeRRtBb794gL6trmMSPFApjfzD+BTC9vdafOQqW+PvAiBCL0MDu5rdyS6VYFkdYqFOYGZjKZJjZOOr8lQRF4o+dQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.1":{"name":"sql-query","version":"0.1.1","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.1","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"ac658f71d6c1a53b25439bf2cb6ed839ff36a9ef","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.1.tgz","integrity":"sha512-9lNQdxTAr7owE36dNiJHol++w+ejGp+VXdGXv7GDoqOvQH/u0yHdMZX/1iOqtLSzb3LNxNM/2IaKh1n1aNaIJw==","signatures":[{"sig":"MEYCIQC6vVLW1Bhee2KcV6PanE5svspmWpqgBeSTkAF7kEAI9AIhAKdCKQg0YReHguaOkI2OCSSEYrUIQwsGaxeVb3UR1Qub","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.2":{"name":"sql-query","version":"0.1.2","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.2","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"53194e2e970813484e2f2a439c73dfbdaefb61dc","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.2.tgz","integrity":"sha512-ksttqyMZyImMEh7zhOWMjFx+u2Li5/szv4qShgjl42QMhM+FzS68u02oEXtNEX3IKakDHNmcJxS6sOfiYxiEKQ==","signatures":[{"sig":"MEYCIQCJafhTkzik71nWF4wrOYYtgdG16NrxWRxQt7BhtQt7qQIhAJSD7kbRybqy/0Wp7mphTPyZfVfNBgaPX+ixiDyowUZH","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.3":{"name":"sql-query","version":"0.1.3","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.3","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"bc2b1b4729b13c590d7627f1a5d84301e15b1def","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.3.tgz","integrity":"sha512-aBDHPHc6sY91Az6KC9tvk4BQ05keHqZIVOhuIoyXD3Bg/iGxvY58xqGLU5sTtUUxWJASWcn1T0yNTD7oPqsozg==","signatures":[{"sig":"MEQCIGMzFAgJ06sPOfvxyJLzTnbtWZTZOngKGeptwVcgRP5NAiAoGf/wVbDFZ1RulXPfobJwfBIceKNcFdbM86lIslldGw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.2.30","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.4":{"name":"sql-query","version":"0.1.4","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.4","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"f96e198566dd7c7f6758cc35c91b1e5fc88bc27a","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.4.tgz","integrity":"sha512-EA8KCiztt9PiJWRm6ihTCSJVSHPtp6L9O67hW+Le3Wz3gWw2bPinP4IsQ3t2LBtyvUaG5TYMPjH81AJNUuvxCg==","signatures":[{"sig":"MEUCIQD2X1iHmwFA+LUU8Yq478Fyc8xLHTWYxbDIiMoQPIguJQIgVblfyQewurZH4kC7fU13puTAGML9ZPZKeFEZHCOEkAo=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.5":{"name":"sql-query","version":"0.1.5","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.5","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"94e956f8bcb2f2f61148b17916285d977675b7a4","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.5.tgz","integrity":"sha512-J/RjiplFm/I8RgqmMeC+N5sWTTPxnZ2U6CSVHffodBO/QrpA+/RgVpevM2M3gVkA7swQq+mHHpww1OIk/I3g4w==","signatures":[{"sig":"MEQCIAqsGYXDATCBWMXnBauLM866vIs9Fbsiomj3fWVCURYrAiBc5FQMXTHuYXLHU54jxJDeu5QmcBDPBch9R7AHKLBE9g==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.6":{"name":"sql-query","version":"0.1.6","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.6","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"6a1c35dd2086dc72f13961f354cbb29d00d8b4a7","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.6.tgz","integrity":"sha512-8W5ugDZ2rvKwbmAupyxEPFdV4co66ZAFbfYuyj9ccQRfh87yzWytH6XEuTXW9b9///4BEfHqfFfmKIibcXRrvw==","signatures":[{"sig":"MEUCIQDusufm+K7ldYAsHzkjr0S+OYCATKKH9gdsJeFfN1wUgAIgS9Vo28DD80HG+Y/4cIXUI/QNQXfM8kpflqNdc7xEE/A=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.7":{"name":"sql-query","version":"0.1.7","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.7","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"29c331e766d5c7e7175e4fea0a624b31b774da36","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.7.tgz","integrity":"sha512-9TpQOkxUk7ENW9o6qKIY0QDuGJAD/CiBHN7K9+1IKa2bJaHkIdb3Bll10AWuK0amCUpJSRDuDacQOLvA6aUljQ==","signatures":[{"sig":"MEYCIQDBEJoNk4xfvQNnucgiQyJ3h/Np2dFsdJwgWWE5fW9g/gIhAIEKUWfPvmSYftXAqyGTB+JLprPfguEhfCI0vH+itnlf","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.8":{"name":"sql-query","version":"0.1.8","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.8","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"ef3353bdffd7adddffafac0734a6a280261bb138","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.8.tgz","integrity":"sha512-N3j2KlTvQh7V442IMpwrommZslIiQnOh55QrARv9T23MEgdwdTDJ8pb7CifCsR8CgoHVmKkZt6GFvVks76E/oA==","signatures":[{"sig":"MEUCIQDoZ6ZozxZtU5Hrv2tN2VLQb11RJ4pfl72UQFYyzjou+wIgFV/zZSKHpJU1nuRo7GjdATAL+dhchM1smBDP5McliDg=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.9":{"name":"sql-query","version":"0.1.9","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.9","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"aa47b8aec0a131875655f257f1950c64f350eaca","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.9.tgz","integrity":"sha512-ADCSplbaQ04DGgio0sLRvetwIypvOyK7TAQI9yIezMEjqsuDpW40yWQV+K+LkHbsfEgbMUk3SE4ohRysPmVKdg==","signatures":[{"sig":"MEQCIGDPX+qPMkqrSeLHoKSuINE9ZRp6bNZygBM3pwPFqItdAiANESACCs8U1Dv4TcOSHhrYWn+exoOoW7KZhjbxtQ+6tg==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.2","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.10":{"name":"sql-query","version":"0.1.10","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.10","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"b49cd4182584141800ca3236c295955d71b0d9fb","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.10.tgz","integrity":"sha512-do/8z9O96tQ1VmCBXwFNtyef2RvW4hZKuVOpbzj0WvEHmuffstSpeVCKrpivjD6fCqsWkFu7Bcm1ZZ0VERQC8g==","signatures":[{"sig":"MEYCIQC93QcFutsXEfCU/shyNVZsAyWgDwhETwcOrVOJhXdFJAIhAMrNcehCjybaJ87uvvjCRLQl9DcYjJZdMBYOeRKDXY+g","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make test"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.11":{"name":"sql-query","version":"0.1.11","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.11","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"653337cb13b1b74f51d0f787644b6280d7521b9e","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.11.tgz","integrity":"sha512-+sqM+OV3ZyxNRfXGtFPkqwoSveGSAvrPy5eeoK1LT3c7Nvw/HL8Q7p896svDEjXKHnRyoCW8WoqB36m7oRhlNw==","signatures":[{"sig":"MEUCIHNBHIoveOFDOa0jT9rRNFD41V8s7nP9+mdfu2/RT08aAiEA/0DwV57V76fjqBPDrDTZaJyCqF2Ul39CDAZnLd7derU=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.12":{"name":"sql-query","version":"0.1.12","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.12","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"aa1656bb10f2174eccf5705c8515758f80a836ce","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.12.tgz","integrity":"sha512-AgcKmONFvHORS9/7dX8Pb9kLiB+BMotfuSE6jrTCIdqShrKGazWSpY+XFWf62FbQtryhymN8dZBWufLI1fQ6zA==","signatures":[{"sig":"MEUCIQDIV3yKSXGifevkRlOydr4A5b2tj66Dmw0b0gAWkd5jQAIgcC8fi5wOmdhAAwj3uDQj2DL5cc3GfDjE3FHKq7MMU/s=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.13":{"name":"sql-query","version":"0.1.13","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.13","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"c2c636a4718073bcbca9c9a91db99e749c48ff5d","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.13.tgz","integrity":"sha512-QsLKnzM7XMcBnXMbIhI9iD65/58L2eqThgHoyavktoobSqf1BPlnnozgg/IWkFZJGZqc806gfWCDm29rrR17Tg==","signatures":[{"sig":"MEUCIQCdrawEJ3ua7dz3j7hC5WP7fGtc+i1AZUJK2aF9Fe+4igIgNHr9TAajEnn1jgTdYGHa547R7gREWz84Ah7Eq7Gds7U=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.14":{"name":"sql-query","version":"0.1.14","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.14","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"4c47a92df28fb09111ecf80cdce477000a52a3b2","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.14.tgz","integrity":"sha512-6lSnkHHfK5pblSQQkBOrefS9lkeh/g+wUV3SvXPxJKEgD2XWekDxTKfYYAem84eUVK/UpYJIBVkmGlnhiLpoXQ==","signatures":[{"sig":"MEYCIQDa8HEz+nc8u7IMjYUkuXhZk0ryrr1HtwzUAZf/jEiLUAIhAPftuxeL0E7RkA5Sl80ud1Cw5YpEXAHFv2EZALRwxak/","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.15":{"name":"sql-query","version":"0.1.15","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.15","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"87dde10480e337970c95727df7589442cfd346fc","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.15.tgz","integrity":"sha512-HXIY8KFbIMoDPW1yJdMuk28m9Qkk9JGNACqQocgCDT05htvHkL7hCnEWt7bkWEAcVywUQt34g9LP0TFbVTZRQA==","signatures":[{"sig":"MEUCIAbS3TZNHFqUY8++O6L1zMZgMUZHO0mEP2E7eP0y6ivEAiEAtKS6+m2YTFjr/cjZQuGdStfDEA9atnBwiKoWTmmcfMk=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.8","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.16":{"name":"sql-query","version":"0.1.16","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.16","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"9ca004160091deefd778100f125f8f217bd375dd","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.16.tgz","integrity":"sha512-HzaR/kJ5N17RzHTjksIYhtOm/FFhjo1+ZjRgxMB65vti48RUj6pKScB9PrfXAATxz3KJUoskw5Yi/ulfl6gmqQ==","signatures":[{"sig":"MEUCIDIMQPcPbAcskbv+icXeSwf0C1IOx8iiD/5PDGx/kxJhAiEA0I8DQOfjh6Ne8/4/0lUwoMOHk+ZDjeeGdsdxRIZSXoY=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","analyse":false,"engines":{"node":"*"},"scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.3.14","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.24":{"name":"sql-query","version":"0.1.24","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.24","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"},{"name":"dxg","email":"arek01@gmail.com"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"aae34804c573b74c235685a6d6a646547c2f47e1","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.24.tgz","integrity":"sha512-xNVaKX7F3MT/1Q4Je1uAvbNhWSNzRmmsN2Xd54H4TRqhUc8ViRAckXNaYEixEBzpQB+ACvj2k7IbjSwREFMUJQ==","signatures":[{"sig":"MEQCIE6QdIER8wL44XCfmKZkD3GmY0QIIbcSGWyp1Euk/jdWAiBss0064Eu9RCrakJMmxKgDyVN0NW6JcV37vdoELUqdDw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","_shasum":"aae34804c573b74c235685a6d6a646547c2f47e1","analyse":false,"engines":{"node":"*"},"gitHead":"30e569ecda7cb99c21552a0140074b4b7597bce7","scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"1.4.28","description":"NodeJS SQL query builder","directories":{},"devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.25":{"name":"sql-query","version":"0.1.25","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.25","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"},{"name":"dxg","email":"arek01@gmail.com"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"f87087da6be495bdfc9b128dbb8a42130af3cddd","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.25.tgz","integrity":"sha512-h5UdH6dGARbWKK6BBQX6GisqQAuZPjm+ZWXXGDuvUHimr3N75Co5o1EhFiaiiqDaC0nOeuo2ApGS0V3pqNidaA==","signatures":[{"sig":"MEQCICqLKixiYKChsMwQKYSnZQ3tFQ4xnWGce/vK5tNka8poAiB59wKItqA1oOj3Tudwu73cNZP7a265wiTA2eGLdfxgBw==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","_shasum":"f87087da6be495bdfc9b128dbb8a42130af3cddd","analyse":false,"engines":{"node":"*"},"gitHead":"5dfae4d7da3f1112ed165031e5b24a562a325a20","scripts":{"test":"make"},"_npmUser":{"name":"dxg","email":"arek01@gmail.com"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"2.7.1","description":"NodeJS SQL query builder","directories":{},"_nodeVersion":"1.6.1","devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.26":{"name":"sql-query","version":"0.1.26","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.26","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"},{"name":"dxg","email":"arek01@gmail.com"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"c8d358be5db1c49cc2055558ba3df64e5a48c441","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.26.tgz","integrity":"sha512-B4tzKwq6zbxdqRoigF11/SUyv6JB0F+BAIH70mmt5Y5GeMkzxGrrrM61o+v5nyubjHCJOvFGiYtkBoMrXgrqaA==","signatures":[{"sig":"MEUCIGU1hqT0VAnt+aI6yDJ9jAErb1tJ9ngotfbZ3P/rtW9+AiEA12rRsQZjt5iYl8NK/hL8zQL1BoM6SjQZ9E4Ll3co5XU=","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}]},"main":"./lib/Query","_from":".","_shasum":"c8d358be5db1c49cc2055558ba3df64e5a48c441","analyse":false,"engines":{"node":"*"},"gitHead":"11acccb46a72180b47940ec4d62f979b25ff13e1","scripts":{"test":"make"},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"repository":{"url":"http://github.com/dresende/node-sql-query"},"_npmVersion":"2.9.1","description":"NodeJS SQL query builder","directories":{},"_nodeVersion":"0.12.3","devDependencies":{"urun":"0.0.6","utest":"0.0.6"}},"0.1.27":{"name":"sql-query","version":"0.1.27","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.27","maintainers":[{"name":"dresende","email":"dresende@thinkdigital.pt"},{"name":"dxg","email":"arek01@gmail.com"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query#readme","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"f854672e1e3c09df773d8b343c6ad0902f92d905","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.27.tgz","fileCount":41,"integrity":"sha512-XXK6W6n0D18YspS/7TziKln8ij9RUnpDzl+qr2hUOqEqrhuilGPhbKBYQ1dkfYoQ0ViNtr2y8RKut06nkAkx2w==","signatures":[{"sig":"MEQCIGoul7SvEJfaUYUlai6yKuAZcCESdfh5a2Jo2gO2fhbfAiA0K480I656guUWh2lRV/22LIxtjPjHWnrlszY811pExQ==","keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA"}],"unpackedSize":76126,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.4\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJbM4EwCRA9TVsSAnZWagAAcwAP/0zc3JZQN+ujq1fMDQYK\n9inyVw+iRDBsQxKrn+4GxAj1K11q7o5CQ7spYIOLXkRp00hgKr7QifQoWB5m\nEa5E4N4d7yaTswAj0mGCKn19NxCFUYsLC4rb5lqU2HpHdDy3bbwAGuCR786m\npGQ1H5iEefh+KRml3AeV0bJmHhlRUpp1X4Xc8z0jlvZyQXAQnbB1GUSTmfsv\ncEIfKT3W/xVd+2HAXRLKUX40Pzso/wGLkbG/5hYUSxfL9BxK1YJBxTmPn5G/\nfoPON5RuGs/m5Bm3Wyfrjb4bM1OHkBsedMjeVulgpuFmi8xFNj3zyBt7B9rB\nuH4tD8UMXV7BgYfp9ywjjyd0quth7YXm3LjeI+qLkxDN8cpVELFEn4xqCfX1\nHi2gKnBFS94pY601Z8423gm/oMMe4w/8ptmaZ5cAojx9X8dhSoAAuGlMhn1Z\nvRhnQ2RkVyRzeIKgOHNJ6Qv5gEIO7hq/IVJmYBb1TKB2iD4Za2Fvd7PZzVmi\nbMyWJoOzHjSZqXYYQ//UnZgVwlRRXtAc1Ta/W+XRaQH+QN5bygsi+HjPJqAw\nWQhXaqZtz7LpKcBJcaZIl2Z2eRcLv5w4PjX4yiEL3NZ8FsnZLVWUhuXIUldm\nQIPkHMScRlfNmCznP/cDSeXhAJbFjP1VwWoJeHtFVM6CK56jTg6hMBZG30TN\nHlue\r\n=V1Jh\r\n-----END PGP SIGNATURE-----\r\n"},"main":"./lib/Query","analyse":false,"engines":{"node":"*"},"gitHead":"244151f8c9180bfb32a81224356a832b560d5b5c","scripts":{"test":"make"},"_npmUser":{"name":"dxg","email":"arek01@gmail.com"},"repository":{"url":"git+ssh://git@github.com/dresende/node-sql-query.git"},"_npmVersion":"5.6.0","description":"NodeJS SQL query builder","directories":{},"_nodeVersion":"8.11.3","_hasShrinkwrap":false,"devDependencies":{"urun":"0.0.8","utest":"0.0.8"},"_npmOperationalInternal":{"tmp":"tmp/sql-query_0.1.27_1530102064388_0.8337398747519815","host":"s3://npm-registry-packages"}},"0.1.28":{"name":"sql-query","version":"0.1.28","keywords":["sql","query"],"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","_id":"sql-query@0.1.28","maintainers":[{"name":"dxg","email":"arek01@gmail.com"},{"name":"dresende","email":"dresende@thinkdigital.pt"}],"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"homepage":"https://github.com/dresende/node-sql-query#readme","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"dist":{"shasum":"d02e736dab818e9712895b761e3ba60cc27a9ff8","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.28.tgz","fileCount":41,"integrity":"sha512-u4LZHEG8Xy41SyTEj1dbUfuVH59h+kmu0Q3l4j83AhnRrosdLw97Yy9dEBxVhATPqqUQzOv8fkawHCylfy4qbg==","signatures":[{"sig":"MEYCIQCPfXnJo37GRhADJgXla59SE+a3IZVswL0KFBBZiS/U8gIhANk5W4XXLJhBzhPD5v4yAeBdwKn31dT/WQVa8lqQl2x7","keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U"}],"unpackedSize":76126},"main":"./lib/Query","analyse":false,"engines":{"node":"*"},"gitHead":"5645279c9352a3c6a182fb733e73b1a0d12e5c78","scripts":{"test":"make"},"_npmUser":{"name":"dxg","email":"arek01@gmail.com"},"repository":{"url":"git+ssh://git@github.com/dresende/node-sql-query.git"},"_npmVersion":"10.9.2","description":"NodeJS SQL query builder","directories":{},"_nodeVersion":"22.14.0","_hasShrinkwrap":false,"devDependencies":{"urun":"0.0.8","utest":"0.0.8"},"_npmOperationalInternal":{"tmp":"tmp/sql-query_0.1.28_1741871448420_0.08335948534106974","host":"s3://npm-registry-packages-npm-production"}},"0.1.29":{"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"name":"sql-query","description":"NodeJS SQL query builder","keywords":["sql","query"],"version":"0.1.29","license":"MIT","repository":{"url":"git+ssh://git@github.com/dresende/node-sql-query.git"},"contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"scripts":{"test":"make"},"main":"./lib/Query","engines":{"node":"*"},"analyse":false,"devDependencies":{"utest":"0.0.8","urun":"0.0.8"},"_id":"sql-query@0.1.29","bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"homepage":"https://github.com/dresende/node-sql-query#readme","_nodeVersion":"24.16.0","_npmVersion":"11.13.0","dist":{"integrity":"sha512-50CUM7iPSiMBzqfTsfVRaPE4/DTDuIjCIULeOxRoDHEUit2vc02zh8POfJ8n6wmLYseEI3WzkLRZ0tc6Z17h4w==","shasum":"99eecf8e22fb67d45c1dfc60a7f020f1210b542e","tarball":"https://registry.npmjs.org/sql-query/-/sql-query-0.1.29.tgz","fileCount":41,"unpackedSize":76640,"signatures":[{"keyid":"SHA256:DhQ8wR5APBvFHLF/+Tc+AYvPOdTpcIDqOhxsBHRwC7U","sig":"MEYCIQCMNSrr9vtXQf2pac0SsXloTO1f8F1ytggSdfi+DBdEbAIhAI3UdDXaKd09Z4Re17tocImuWdIWpxRJ4f07rFvyYeV0"}]},"_npmUser":{"name":"dresende","email":"dresende@thinkdigital.pt"},"directories":{},"maintainers":[{"name":"dxg","email":"arek01@gmail.com"},{"name":"dresende","email":"dresende@thinkdigital.pt"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages-npm-production","tmp":"tmp/sql-query_0.1.29_1785076131969_0.621661050741861"},"_hasShrinkwrap":false}},"time":{"created":"2013-03-06T21:33:13.075Z","modified":"2026-07-26T14:28:52.276Z","0.0.1":"2013-03-06T21:33:15.205Z","0.0.2":"2013-03-07T00:40:19.805Z","0.0.3":"2013-03-07T16:17:34.854Z","0.0.4":"2013-03-07T19:48:57.742Z","0.0.5":"2013-03-07T19:56:56.329Z","0.0.6":"2013-03-07T20:35:21.869Z","0.0.7":"2013-03-07T21:26:07.874Z","0.0.8":"2013-03-10T22:57:26.301Z","0.0.9":"2013-03-11T20:30:20.856Z","0.0.10":"2013-03-17T23:14:27.481Z","0.0.11":"2013-03-19T16:04:15.332Z","0.0.12":"2013-04-03T00:17:59.475Z","0.0.13":"2013-04-03T11:49:54.358Z","0.0.14":"2013-04-03T12:15:48.232Z","0.0.15":"2013-04-05T18:49:35.707Z","0.0.17":"2013-04-08T14:25:20.410Z","0.0.18":"2013-04-16T17:07:33.618Z","0.0.19":"2013-04-17T23:19:50.412Z","0.0.20":"2013-04-18T14:55:57.142Z","0.0.21":"2013-04-24T21:58:24.307Z","0.0.22":"2013-05-02T21:48:30.279Z","0.0.23":"2013-05-27T22:06:01.086Z","0.0.24":"2013-05-27T22:50:55.077Z","0.0.25":"2013-05-27T23:33:34.414Z","0.0.26":"2013-06-03T11:12:24.621Z","0.0.27":"2013-06-15T10:23:55.120Z","0.0.28":"2013-06-20T15:48:10.657Z","0.0.29":"2013-06-27T18:20:41.999Z","0.1.0":"2013-07-03T22:15:22.515Z","0.1.1":"2013-07-03T22:24:31.067Z","0.1.2":"2013-07-04T11:00:42.426Z","0.1.3":"2013-07-07T20:19:37.401Z","0.1.4":"2013-07-14T14:09:26.319Z","0.1.5":"2013-07-15T10:22:48.808Z","0.1.6":"2013-07-17T15:08:55.384Z","0.1.7":"2013-07-23T10:22:37.792Z","0.1.8":"2013-07-23T17:08:20.326Z","0.1.9":"2013-08-03T07:58:04.490Z","0.1.10":"2013-08-20T10:57:09.670Z","0.1.11":"2013-08-22T08:32:31.521Z","0.1.12":"2013-08-28T21:46:21.099Z","0.1.13":"2013-09-06T15:35:26.923Z","0.1.14":"2013-09-10T18:57:14.377Z","0.1.15":"2013-09-10T19:09:21.707Z","0.1.16":"2013-12-05T18:24:55.150Z","0.1.24":"2014-12-22T18:32:55.877Z","0.1.25":"2015-03-22T01:35:30.539Z","0.1.26":"2015-05-16T13:11:24.660Z","0.1.27":"2018-06-27T12:21:04.496Z","0.1.28":"2025-03-13T13:10:48.612Z","0.1.29":"2026-07-26T14:28:52.119Z"},"bugs":{"url":"https://github.com/dresende/node-sql-query/issues"},"author":{"name":"Diogo Resende","email":"dresende@thinkdigital.pt"},"license":"MIT","homepage":"https://github.com/dresende/node-sql-query#readme","keywords":["sql","query"],"repository":{"url":"git+ssh://git@github.com/dresende/node-sql-query.git"},"description":"NodeJS SQL query builder","contributors":[{"name":"Benjamin Pannell","email":"admin@sierrasoftworks.com"},{"name":"Arek W"}],"maintainers":[{"name":"dxg","email":"arek01@gmail.com"},{"name":"dresende","email":"dresende@thinkdigital.pt"}],"readme":"# NodeJS SQL query builder\n\n[![Build Status](https://secure.travis-ci.org/dresende/node-sql-query.png?branch=master)](http://travis-ci.org/dresende/node-sql-query)\n\n## Install\n\n```sh\nnpm install sql-query --save\n```\n\n## Dialects\n\n- MySQL\n- PostgreSQL\n- SQLite\n- MSSQL\n\n## About\n\nThis module is used by [ORM](http://dresende.github.com/node-orm2) to build SQL queries in the different supported dialects.\nSorry the API documentation is not complete. There are tests in ./test/integration that you can read.\n\n\n# Usage\n```js\nvar sql = require('sql-query'),\n  sqlQuery = sql.Query(); //for dialect: sql.Query('postgresql')\n```\n\n## Create\n```js\nvar sqlCreate = sqlQuery.create();\n\nsqlCreate\n  .table('table1')\n  .build()\n\n\"CREATE TABLE 'table1'()\"\n\n\nsqlCreate\n  .table('table1')\n  .field('id','id')\n  .build()\n\n\"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT)\"\n\n\nsqlCreate\n  .table('table1')\n  .fields({id: 'id', a_text: 'text'})\n  .build()\n\n\"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_text' TEXT)\"\n\n\nsqlCreate\n  .table('table1')\n  .fields({id: 'id', a_num: 'int'})\n  .build()\n\n\"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_num' INTEGER)\"\n\n\nsqlCreate\n  .table('table1')\n  .fields({id: 'id', a_num: 'float'})\n  .build()\n\n\"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_num' FLOAT(12,2))\"\n\n\nsqlCreate\n  .table('table1')\n  .fields({id: 'id', a_bool: 'bool'})\n  .build()\n\n\"CREATE TABLE 'table1'('id' INTEGER PRIMARY KEY AUTO_INCREMENT,'a_bool' TINYINT(1))\"\n```\n\n## Select\n```js\nvar sqlSelect = sqlQuery.select();\n\nsqlSelect\n  .from('table1')\n  .build();\n\n\"SELECT * FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id', 'name')\n  .build();\n\n\"SELECT `id`, `name` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id', 'name')\n  .as('label')\n  .build();\n\n\"SELECT `id`, `name` AS `label` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id', 'name')\n  .select('title')\n  .as('label')\n  .build();\n\n\"SELECT `id`, `name`, `title` AS `label` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id', 'name')\n  .as('label')\n  .select('title')\n  .build();\n\n\"SELECT `id`, `name` AS `label`, `title` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select([ 'id', 'name' ])\n  .build();\n\n\"SELECT `id`, `name` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select()\n  .build();\n\n\"SELECT * FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select(['abc','def', { a: 'ghi', sql: 'SOMEFUNC(ghi)' }])\n  .build();\n\n\"SELECT `abc`, `def`, (SOMEFUNC(ghi)) AS `ghi` FROM `table1`\"\n\n\nsqlSelect\n  .calculateFoundRows()\n  .from('table1')\n  .build();\n\n\"SELECT SQL_CALC_FOUND_ROWS * FROM `table1`\"\n\n\nsqlSelect\n  .calculateFoundRows()\n  .from('table1')\n  .select('id')\n  .build();\n\n\"SELECT SQL_CALC_FOUND_ROWS `id` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id1', 'name')\n  .from('table2', 'id2', 'id1')\n  .select('id2')\n  .build();\n\n\"SELECT `t1`.`id1`, `t1`.`name`, `t2`.`id2` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id1')\n  .from('table2', 'id2', 'id1', { joinType: 'left outer' })\n  .select('id2')\n  .build();\n\n\"SELECT `t1`.`id1`, `t2`.`id2` FROM `table1` `t1` LEFT OUTER JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .select('id1', 'name')\n  .from('table2', 'id2', 'table1', 'id1')\n  .select('id2')\n  .build();\n\n\"SELECT `t1`.`id1`, `t1`.`name`, `t2`.`id2` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id2', 'table1', 'id1')\n  .count()\n  .build();\n\n\"SELECT COUNT(*) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id2', 'table1', 'id1')\n  .count(null, 'c')\n  .build();\n\n\"SELECT COUNT(*) AS `c` FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id2', 'table1', 'id1')\n  .count('id')\n  .build();\n\n\"SELECT COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .count('id')\n  .from('table2', 'id2', 'table1', 'id1')\n  .count('id')\n  .build();\n\n\"SELECT COUNT(`t1`.`id`), COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id2', 'table1', 'id1')\n  .count('id')\n  .count('col')\n  .build();\n\n\"SELECT COUNT(`t2`.`id`), COUNT(`t2`.`col`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id2', 'table1', 'id1')\n  .fun('AVG', 'col')\n  .build();\n\n\"SELECT AVG(`t2`.`col`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2` = `t1`.`id1`\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2',['id2a', 'id2b'], 'table1', ['id1a', 'id1b'])\n  .count('id')\n  .build();\n\n\"SELECT COUNT(`t2`.`id`) FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id2a` = `t1`.`id1a` AND `t2`.`id2b` = `t1`.`id1b`\"\n```\n\n## Where\n```js\nvar sqlSelect = sqlQuery.select();\n\nsqlSelect\n  .from('table1')\n  .where()\n  .build();\n\n\"SELECT * FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .where(null)\n  .build();\n\n\"SELECT * FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: 1 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: 0 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = 0\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: null })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` IS NULL\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.eq(null) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` IS NULL\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.ne(null) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` IS NOT NULL\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: undefined })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` IS NULL\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: false })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = false\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: \"\" })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = ''\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: true })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = true\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: 'a' })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = 'a'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: 'a\\'' })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = 'a\\\\''\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: [ 1, 2, 3 ] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` IN (1, 2, 3)\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: [] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE FALSE\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col1: 1, col2: 2 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col1` = 1 AND `col2` = 2\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col1: 1 }, { col2: 2 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE (`col1` = 1) AND (`col2` = 2)\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: 1 }).where({ col: 2 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE (`col` = 1) AND (`col` = 2)\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col1: 1, col2: 2 }).where({ col3: 3 })\n  .build();\n\n\"SELECT * FROM `table1` WHERE (`col1` = 1 AND `col2` = 2) AND (`col3` = 3)\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id', 'id')\n  .where('table1', { col: 1 }, 'table2', { col: 2 })\n  .build();\n\n\"SELECT * FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id` = `t1`.`id` WHERE (`t1`.`col` = 1) AND (`t2`.`col` = 2)\"\n\n\nsqlSelect\n  .from('table1')\n  .from('table2', 'id', 'id')\n  .where('table1', { col: 1 }, { col: 2 })\n  .build();\n\n\"SELECT * FROM `table1` `t1` JOIN `table2` `t2` ON `t2`.`id` = `t1`.`id` WHERE (`t1`.`col` = 1) AND (`col` = 2)\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.gt(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` > 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.gte(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` >= 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.lt(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` < 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.lte(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` <= 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.eq(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` = 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.ne(1) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` <> 1\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.between('a', 'b') })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` BETWEEN 'a' AND 'b'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.not_between('a', 'b') })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` NOT BETWEEN 'a' AND 'b'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.like('abc') })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` LIKE 'abc'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: \n  sql.not_like('abc') })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` NOT LIKE 'abc'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ col: sql.not_in([ 1, 2, 3 ]) })\n  .build();\n\n\"SELECT * FROM `table1` WHERE `col` NOT IN (1, 2, 3)\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ __sql: [[\"LOWER(`stuff`) LIKE 'peaches'\"]] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ __sql: [[\"LOWER(`stuff`) LIKE ?\", ['peaches']]] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches'\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ __sql: [[\"LOWER(`stuff`) LIKE ? AND `number` > ?\", ['peaches', 12]]] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches' AND `number` > 12\"\n\n\nsqlSelect\n  .from('table1')\n  .where({ __sql: [[\"LOWER(`stuff`) LIKE ? AND `number` == ?\", ['peaches']]] })\n  .build();\n\n\"SELECT * FROM `table1` WHERE LOWER(`stuff`) LIKE 'peaches' AND `number` == NULL\"\n```\n\n## Order\n```js\nvar sqlSelect = sqlQuery.select();\n\nsqlSelect\n  .from('table1')\n  .order('col')\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY `col` ASC\"\n\n\nsqlSelect\n  .from('table1')\n  .order('col', 'A')\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY `col` ASC\"\n\n\nsqlSelect\n  .from('table1')\n  .order('col', 'Z')\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY `col` DESC\"\n\n\nsqlSelect\n  .from('table1')\n  .order('col').order('col2', 'Z')\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY `col` ASC, `col2` DESC\"\n\n\nsqlSelect\n  .from('table1')\n  .order('col', [])\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY col\"\n\n\nsqlSelect\n  .from('table1')\n  .order('?? DESC', ['col'])\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY `col` DESC\"\n\n\nsqlSelect\n  .from('table1')\n  .order('ST_Distance(??, ST_GeomFromText(?,4326))', ['geopoint', 'POINT(-68.3394 27.5578)'])\n  .build();\n\n\"SELECT * FROM `table1` ORDER BY ST_Distance(`geopoint`, ST_GeomFromText('POINT(-68.3394 27.5578)',4326))\"\n```\n\n## Limit\n\n```js\nvar sqlSelect = sqlQuery.select();\n\nsqlSelect\n  .from('table1')\n  .limit(123)\n  .build();\n\n\"SELECT * FROM `table1` LIMIT 123\"\n\n\nsqlSelect\n  .from('table1')\n  .limit('123456789')\n  .build();\n\n\"SELECT * FROM `table1` LIMIT 123456789\"\n```\n\n## Select function\n\n```js\nvar sqlSelect = sqlQuery.select();\n\nsqlSelect\n  .from('table1')\n  .fun('myfun', 'col1')\n  .build();\n\n\"SELECT MYFUN(`col1`) FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .fun('myfun', [ 'col1', 'col2'])\n  .build();\n\n\"SELECT MYFUN(`col1`, `col2`) FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .fun('dbo.fnBalance', [ 80, null, null], 'balance')\n  .build();\n\n\"SELECT DBO.FNBALANCE(80, NULL, NULL) AS `balance` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .fun('myfun', [ 'col1', 'col2'], 'alias')\n  .build();\n\n\"SELECT MYFUN(`col1`, `col2`) AS `alias` FROM `table1`\"\n\n\nsqlSelect\n  .from('table1')\n  .fun('myfun', [ 'col1', sqlQuery.Text('col2') ], 'alias')\n  .build();\n\n\"SELECT MYFUN(`col1`, 'col2') AS `alias` FROM `table1`\"\n```\n\n## Insert\n\n```js\nvar sqlInsert = sqlQuery.insert();\n\nsqlInsert\n  .into('table1')\n  .build();\n\n\"INSERT INTO `table1`\"\n\n\nsqlInsert\n  .into('table1')\n  .set({})\n  .build();\n\n\"INSERT INTO `table1` VALUES()\"\n\n\nsqlInsert\n  .into('table1')\n  .set({ col: 1 })\n  .build();\n\n\"INSERT INTO `table1` (`col`) VALUES (1)\"\n\n\nsqlInsert\n  .into('table1')\n  .set({ col1: 1, col2: 'a' })\n  .build();\n\n\"INSERT INTO `table1` (`col1`, `col2`) VALUES (1, 'a')\"\n```\n\n## Update\n\n```js\nvar sqlUpdate = sqlQuery.update()\n\nsqlUpdate\n  .into('table1')\n  .build();\n\n\"UPDATE `table1`\"\n\n\nsqlUpdate\n  .into('table1')\n  .set({ col: 1 })\n  .build();\n\n\"UPDATE `table1` SET `col` = 1\"\n\n\nsqlUpdate\n  .into('table1')\n  .set({ col1: 1, col2: 2 })\n  .build();\n\n\"UPDATE `table1` SET `col1` = 1, `col2` = 2\"\n\n\nsqlUpdate\n  .into('table1')\n  .set({ col1: 1, col2: 2 }).where({ id: 3 })\n  .build();\n\n\"UPDATE `table1` SET `col1` = 1, `col2` = 2 WHERE `id` = 3\"\n```\n","readmeFilename":"Readme.md","users":{"n370":true,"qujian":true,"natarajanmca11":true}}