{"_id":"sql-parser","_rev":"36-847c4f390cf6a9f4be7b97131b386a53","name":"sql-parser","description":"Lexer and Parser for SQL Syntax","dist-tags":{"latest":"0.5.0"},"versions":{"0.1.1":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.1","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.1/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.1","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"aba5f6cb5c3ee2585844905ab2de10fae76d86d2","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.1.tgz","integrity":"sha512-RtkjVj0G3lEmnsbAqnNtJgOa2z8wMkBz894w/+onR6/dL0uamhSl82wQHKyDW8V0TzlnovtenDaRy5xxF3rPag==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCZgogaHpKJW2IE6thPqCkY4bQ8tz0KnW+AQlz8Yh+S0wIgXzFRwQcvXz6KP6XQtBDFBwgnYKbGP/7dyJj9L/e945k="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.2":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.2","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.2/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.2","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"19aff803ff9e0eccb6c16a62beab29e9b6046612","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.2.tgz","integrity":"sha512-QMVK6V9+EWSM/AVjIFkB8lEg6ubPgMcka8JvPp7VnWkGPKFFAAgV9uqFfBSKQNbygJlRfxR6/XFkw++AlKObXA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC38EE5Y3MDgmZ9mO4JN9KWnqsLSgCtt5JtU/R+pX1KYQIgXkrujPU+TRyrZbirM7y5zE+5tvGbgjGeA0pRDml17Ss="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.3":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.3","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.3/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.3","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"2e82cf058e7f337e65fa302e9a38753f79a54d7b","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.3.tgz","integrity":"sha512-0uoivNtq2JO4STygAUCwxCUokuodjNajZVw5nPMnmaG2GCIUx9GIGTJqQq0e2316u2fheekiHyrtn+b9H+SeKw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCOISqRAQhC5k1D1fBGYRb8EGYw/wM/3hYyoxBrBlw9FgIgLnZfFKO7BalCiniVrrMgHqAhaQK1h094oybjAo/KpMY="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.4":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.4","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.4/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.4","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"c6fba5bf2ba3c9580d57c1f68b07819cacd16f71","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.4.tgz","integrity":"sha512-nrvX0bZXDvplvqIyNUY/JT/ZPtXnttbvqc8Q/7q2mQbm0KvsBZRbuMVD/uV6IHCsMeZT4BE1FHyRAhrCgjupPw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCvcwz91sTgfHZ7DkHDo8iNm7cNJDMd1BH/pGlX3R69nwIgGTbI0H7YO/axvs3XOKZO5YqTiClPnQFZyek/rgQ4nG0="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.5":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.5","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.5/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.5","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"b61c4f1889de1534c4d1c952aea6b8b67bcfac8c","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.5.tgz","integrity":"sha512-X/yrsj7vyZT3ZAJg+hnM+SYpNW52OU0+bAUR7M5kPp9qM+sCQ3UU5D/GdE3rAtK30Mnhm+BshTnCZtZewuiSEA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQDli8T6CTrlbqUMvR/efjuJDy4HQJKQ8EpUhk0DpGLbIAIhAJZMrT/Sqd4kLzML/9aw/s/plcE4ix4ZZjQd1EG1Ub7+"}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.6":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.6","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.6/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.6","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"a13d65f1c6bdcfd82eb35cbe72f506808735abb9","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.6.tgz","integrity":"sha512-Okz4vptepHoydPvVaoSoTMPv3O0NuBPT9voAtNSqy1kbzmZe0diRUde56ayKA0pHj0NczoiIQ0WKxl59t3g8ew==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCqRRyrP60r+vEH4jrxuS3gN9p9mIiahMbmaX6H+cdJKAIhAN/lW5wWXTiCNOhopReH8Y0I1b+1iJqChdzd6V+0DrmZ"}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.7":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.7","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.7/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.7","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"592b1463fe27d567a437e14755bf83f41435a758","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.7.tgz","integrity":"sha512-jl1msI5N20xf26UiZAAMaUKo3d7YtrtkNW4UCu9iwmwM1I14NHdVumGHwFDebNM3W3S5IfZxCLnjZ8zQ5FqCUw==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEYCIQCgibvi7c2YeICpMnThC6z4G2LfhyUNYg8C/go01FvmoQIhANwabsyiw03R+Oqz46dPqBixQfjkmj/7x3cISTSA+o2D"}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.8":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.8","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmJsonOpts":{"file":"/Users/andy/.npm/sql-parser/0.1.8/package/package.json","wscript":false,"contributors":false,"serverjs":false},"_id":"sql-parser@0.1.8","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.27","_nodeVersion":"v0.4.11","_defaultsLoaded":true,"dist":{"shasum":"b6f15427d6cb9d7594b83ab4bf108faad9193c5a","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.8.tgz","integrity":"sha512-1X19udwzXifvS7fjA9conAukXo5n4+jhGJ4MohPR87pbfgTi9ZKOLM6YGMjqka9YkQvRIK4bFzrUa7lONrBh6A==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCzMHZ4M+/XJbWy2d2AXovREGudkgSl+AKhW3fSSuNsNwIgeYtHSZDsmZL/OzdqpP00bjUz1bmEB8KgiIMsdX9cTAQ="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"_npmUser":{"name":"andykent","email":"andy.kent@me.com"}},"0.1.9":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.1.9","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.0.1","jison":"0.2.11"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"_id":"sql-parser@0.1.9","devDependencies":{},"_engineSupported":true,"_npmVersion":"1.0.104","_nodeVersion":"v0.6.0","_defaultsLoaded":true,"dist":{"shasum":"150d0bfdc1237672d4712897a36354326b0b631e","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.1.9.tgz","integrity":"sha512-xWsDOVW1cVXFQlwOKcFTZCDc9FZoHSSiyTWZQu4zs71+3gJShp6phWv9dDZiPqzaSYFdPRRPu/FgSWZw4xZXsA==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIB0x3Mjla9fwp2eEAKXYxxixzcWkW8uTUWr8Wm9A92BWAiEAiBcVyKdmsDjdTU/7VjdcqAbU+n29MYlD1oqye7rVgCI="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}]},"0.2.0":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.2.0","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.1.3","jison":"https://github.com/pvwoods/jison/tarball/master"},"devDependencies":{"mocha":"0.0.8","should":"0.3.2"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"_id":"sql-parser@0.2.0","_engineSupported":true,"_npmVersion":"1.1.0-alpha-2","_nodeVersion":"v0.6.3","_defaultsLoaded":true,"dist":{"shasum":"2b0bee67a19175631a0a68dfabf2be0d2bbcd3f9","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.2.0.tgz","integrity":"sha512-pHf7clIfkxmt+3k+1zht+xlTFnalktspbnNwXWsqMmMCIVPFY47gsGw8dksp5Y/O6k/ZUt0jqYzTJHEmr5m6TQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQC0Vw5eYOtP3Luu4NyDw11jqhKbGz33XEEMQALj1+vHXwIgQOMPoGpqGX86AsYyo9yEJGqntXS0j9rWgi+B92YaDLk="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}]},"0.2.1":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.2.1","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.1.3","jison":"https://github.com/pvwoods/jison/tarball/master"},"devDependencies":{"mocha":"0.0.8","should":"0.3.2"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"_id":"sql-parser@0.2.1","_engineSupported":true,"_npmVersion":"1.1.0-alpha-2","_nodeVersion":"v0.6.3","_defaultsLoaded":true,"dist":{"shasum":"80d06ff4f44243019758d0b2950ee19b98a65443","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.2.1.tgz","integrity":"sha512-Jb2oWNr/zThSO3XtTHKV6Up30aRkpxrogU+SFhA5Kbs+wkrDomr8ui1zyNO3+SePPOh85MjSDisZVD/9sog9Cg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIHc3rt6hPWD1oZPO75z/BHCfUrczT3YqKiBBzOsmXnSZAiBYT8LzCf8xwWIQNUFNphVjz5iPP+mUm6+kpbcrhwxaqg=="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}]},"0.3.0":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.3.0","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{"coffee-script":"1.1.3","jison":"https://github.com/pvwoods/jison/tarball/master"},"devDependencies":{"mocha":"0.3.2","should":"0.3.2"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"_id":"sql-parser@0.3.0","_engineSupported":true,"_npmVersion":"1.1.0-alpha-2","_nodeVersion":"v0.6.3","_defaultsLoaded":true,"dist":{"shasum":"6516e16a663557b3770866b403ea2a2d0d6a791d","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.3.0.tgz","integrity":"sha512-4iyFf0G2wvqh+A3XJmRMhgf62Upck86UkFD87L/nCZYkYrUApEEVtlD7xxvg5G85Ghlzif1hjEEZPKeccrmOlg==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQDqKm/OkjxYdEwp/DlgSQlG/A1a+VLpUtRT3irj4Fu5WAIgcw3eKTIX7rwivz1Z4a/dw+73KasGkbJAwiJ0pBqWMj4="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}]},"0.4.0":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.4.0","author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{},"devDependencies":{"jison":"https://github.com/pvwoods/jison/tarball/master","coffee-script":"1.2.0","mocha":"0.3.2","should":"0.3.2"},"engines":["node"],"repository":{"type":"git","url":"git://github.com/forward/sql-parser.git"},"_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"_id":"sql-parser@0.4.0","_engineSupported":true,"_npmVersion":"1.1.0-beta-4","_nodeVersion":"v0.6.6","_defaultsLoaded":true,"dist":{"shasum":"0c181fc4f2c91e447fb251a42b32519f27e29140","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.4.0.tgz","integrity":"sha512-sr8QLxr2jKUTaU6razOMbLLRwLYxkvnLHHpAd0I+GyJv3SlHSYWnxO7YzUfMwfACNCYNDeMoBGLNShxvtT2kEQ==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIF0ZutEzw0mzDepmukz824fLM7dWzKoz+xOjGeMg73PvAiEApM/TWDBnAStW336zcEg3zw0rEATmwNq8mLYe9OZCxcQ="}]},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}]},"0.5.0":{"name":"sql-parser","description":"Lexer and Parser for SQL Syntax","version":"0.5.0","scripts":{"test":"cake build && ./node_modules/.bin/mocha --require should --compilers coffee:coffee-script/register"},"author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"directories":{"lib":"./lib"},"dependencies":{},"devDependencies":{"jison":"0.4.15","coffee-script":"1.8.0","mocha":"2.0.1","should":"4.1.0"},"engines":["node"],"repository":{"type":"git","url":"http://github.com/forward/sql-parser.git"},"gitHead":"053dfb556368b88c2defbd2724248b6f2892cf01","bugs":{"url":"https://github.com/forward/sql-parser/issues"},"homepage":"https://github.com/forward/sql-parser","_id":"sql-parser@0.5.0","_shasum":"a79b6e66452f3d615b211989f006f34033bc436a","_from":".","_npmVersion":"2.1.8","_nodeVersion":"0.10.30","_npmUser":{"name":"andykent","email":"andy.kent@me.com"},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"dist":{"shasum":"a79b6e66452f3d615b211989f006f34033bc436a","tarball":"https://registry.npmjs.org/sql-parser/-/sql-parser-0.5.0.tgz","integrity":"sha512-0Lw6wAUF4MGJ5pRKY6W8emkhWB7WmQ/5bioEzVVk0oI7kIvACJxJCdHD/K8EKQb+kniRPOuxhSnmd/kU+gn/9Q==","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIE1Pgl6Z8VOCRE9fyLqrF6hsy93uc/WxYqaecUU3bI+jAiAkK5EF37AGcWvqylcfIOymUdmFTHYLjk8pBxL5vQS7DQ=="}]}}},"maintainers":[{"name":"andykent","email":"andy.kent@me.com"}],"time":{"modified":"2022-06-26T23:14:38.896Z","created":"2011-09-30T14:53:35.187Z","0.1.1":"2011-12-07T15:03:25.315Z","0.1.2":"2011-12-07T15:03:25.315Z","0.1.3":"2011-12-07T15:03:25.315Z","0.1.4":"2011-12-07T15:03:25.315Z","0.1.5":"2011-12-07T15:03:25.315Z","0.1.6":"2011-12-07T15:03:25.315Z","0.1.7":"2011-12-07T15:03:25.315Z","0.1.8":"2011-12-07T15:03:25.315Z","0.1.9":"2011-11-23T17:58:22.006Z","0.2.0":"2011-11-29T00:01:30.439Z","0.2.1":"2011-11-29T17:58:10.320Z","0.3.0":"2011-12-07T15:03:25.315Z","0.4.0":"2011-12-24T15:52:26.349Z","0.5.0":"2015-03-17T10:21:21.295Z"},"author":{"name":"Andy Kent","email":"andy@forward.co.uk"},"repository":{"type":"git","url":"http://github.com/forward/sql-parser.git"},"readme":"SQL Parser\n==========\n\nSQL Parser is a lexer, grammar and parser for SQL written in JS. Currently it is only capable of parsing fairly basic SELECT queries but full SQL support will hopefully come in time. See the specs for examples of currently supported queries.\n\nLexer\n-----\n\nThe lexer takes a SQL query string as input and returns a stream of tokens in the format \n\n    ['NAME', 'value', lineNumber]\n\nHere is a simple example...\n\n    lexer.tokenize('select * from my_table')\n\n    [\n      ['SELECT','select',1], \n      ['STAR','*',1], \n      ['FROM','from',1], \n      ['LITERAL','my_table',1]\n    ]\n\nThe tokenized output is in a format compatible with JISON.\n\n\nParser\n------\n\nThe parser only currently supports SELECT queries but is able to produce a Select object with properties for where, group, order, limit. See lib/nodes.coffee for more info of the returned object structure. Calling .toString() on a Select object should give you back a well formatted version of the original SQL input.\n\n    tokens = lexer.tokenize('select * from my_table where foo = 'bar')\n    parser.parse(tokens).toString()\n\n    SELECT *\n      FROM `my_table`\n      WHERE `foo` = 'bar'\n    \n\n\nCredits\n-------\n\nA lot of the boilerplate and compilation code in this project is borrowed from the CoffeeScript project as it was the best example of a project using JISON that I could find. Thanks.","readmeFilename":"README.md","homepage":"https://github.com/forward/sql-parser","bugs":{"url":"https://github.com/forward/sql-parser/issues"},"users":{"shanewholloway":true,"asaupup":true,"nuwaio":true}}