{"_id":"prettier-sql","_rev":"5-1a8f37e5c9d3edef7e56e5ad29b2a004","name":"prettier-sql","dist-tags":{"beta":"5.0.0-beta.1","latest":"5.1.1"},"versions":{"5.0.0-beta.1":{"name":"prettier-sql","version":"5.0.0-beta.1","description":"Format whitespace in a SQL query to make it more readable","license":"MIT","main":"lib/sqlFormatter.js","bin":{"prettier-sql":"bin/sqlfmt.js"},"keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"contributors":[{"name":"Adrien Pyke","email":"adpyke@gmail.com"},{"name":"Andrew"},{"name":"Benjamin Bellamy"},{"name":"bingou"},{"name":"Damon Davison","email":"ddavison@avalere.com"},{"name":"Davut Can Abacigil","email":"can@teamsql.io"},{"name":"Erik Hirmo","email":"erik.hirmo@roguewave.com"},{"name":"George Leslie-Waksman","email":"waksman@gmail.com"},{"name":"Ian Campbell","email":"icampbell@immuta.com"},{"name":"ivan baktsheev"},{"name":"João Pimentel Ferreira"},{"name":"Martin Nowak","email":"code@dawg.eu"},{"name":"Matheus Salmi","email":"mathsalmi@gmail.com"},{"name":"Matheus Teixeira","email":"matheus.mtxr@gmail.com"},{"name":"Nicolas Dermine","email":"nicolas.dermine@gmail.com"},{"name":"Offir Baron","email":"ofir@panoply.io"},{"name":"Olexandr Sydorchuk","email":"olexandr.syd@gmail.com"},{"name":"Rafael Pinto","email":"raprp@posteo.de"},{"name":"Rahel Rjadnev-Meristo","email":"rahelini@gmail.com"},{"name":"Rene Saarsoo","email":"nene@triin.net"},{"name":"Rodrigo Stuchi"},{"name":"Sasha Aliashkevich","email":"olsender@gmail.com"},{"name":"Sean Song","email":"mail@seansong.dev"},{"name":"Sergei Egorov","email":"sergei.egorov@zeroturnaround.com"},{"name":"Tyler Jones","email":"tyler.jones@txwormhole.com"},{"name":"Uku Pattak","email":"ukupat@gmail.com"}],"scripts":{"clean":"rimraf lib dist","lint":"eslint .","pretty":"prettier --write .","fix":"npm run pretty && eslint --fix .","pretty:check":"prettier --check .","test":"jest","test:watch":"npm run test -- --watch","check":"npm run pretty:check && npm run lint && npm run test","prepare":"npm run clean && npm run fix && npm run check && npm run build","build:commonjs":"babel src --out-dir lib --extensions .ts","build:umd":"webpack --config webpack.dev.js","build:umd:min":"webpack --config webpack.prod.js","build":"npm run build:commonjs && npm run build:umd && npm run build:umd:min"},"pre-commit":["fix"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"dependencies":{"argparse":"^2.0.1"},"devDependencies":{"@babel/cli":"^7.10.4","@babel/core":"^7.10.4","@babel/plugin-proposal-class-properties":"^7.10.4","@babel/preset-env":"^7.10.4","@babel/preset-typescript":"^7.15.0","@types/babel__core":"^7.1.15","@typescript-eslint/eslint-plugin":"^4.31.2","@typescript-eslint/parser":"^4.32.0","babel-eslint":"^10.1.0","babel-jest":"^26.1.0","babel-loader":"^8.1.0","babel-plugin-add-module-exports":"^1.0.2","dedent-js":"^1.0.1","eslint":"^7.4.0","eslint-config-airbnb-base":"^14.2.0","eslint-config-airbnb-typescript":"^14.0.0","eslint-config-prettier":"^6.11.0","eslint-plugin-import":"^2.22.0","eslint-plugin-prettier":"^3.1.4","jest":"^26.1.0","pre-commit":"^1.2.2","prettier":"^2.0.5","release-it":"^14.11.7","rimraf":"^3.0.2","typescript":"^4.3.5","webpack":"^4.43.0","webpack-cli":"^3.3.12","webpack-merge":"^5.0.8"},"jest":{"roots":["test"],"testRegex":".*Test","collectCoverage":true},"gitHead":"ed4af994e19d2e76c9eacf7a547e2f5fb6045d4c","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","_id":"prettier-sql@5.0.0-beta.1","_nodeVersion":"14.17.0","_npmVersion":"6.14.13","dist":{"integrity":"sha512-Eu4KMs1m2CBTeJnPKtvAcQQnOkrGbrsKkS5xxEIpMl+eBrJNOM83dDYlZIVdd5OxlfCXCXJbtnTC+CKlVRy1OA==","shasum":"7e032f0c1fb0213f5cdadff7f0b5545e2f684d03","tarball":"https://registry.npmjs.org/prettier-sql/-/prettier-sql-5.0.0-beta.1.tgz","fileCount":48,"unpackedSize":1598058,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhkuViCRA9TVsSAnZWagAAPTgP/3TjNPY8yUdEfq9ixrYX\nGZI1kB0r2L6N+CB/aw6L8Wni+KrfdsVFoqFbJENOk5t5nLfUKgDVKM+6u4xQ\nHktPoF828tYIEo+k1/I7ge1MO64JryPo64DL0vUntd4HYQENjKAKucfTFPfH\ndGIh8bTAZfX3gxXSupdYZZJXuq0KLu+5yiHdA6Mq5dbL7/sem/bve32/ZuBS\npWf+CNS6c1+VGTrHIgeDOi2a9zI7peuKm9HvZHdFcZ6yO+wqIKg9cNrGTihp\nZzyv+cCKoU2gJ8PtaHfVimVUbR/Xdoy1qcOt69Pt0lH1I36grZnxdGr/c89I\nGMLLaNyQ5jth0G58KWo2P/uyFaLYXZ9H+iakzP20oer2rXoT5q2cUaVWau+z\nwkhh42Ni0TfbuANRkNJs4uTgEQE/EoU2sQ5F3d5unOIEa0hSy/83dwInkNRS\nTsoe3g7+6mS+a9KBe6RMny7uOoHmWJ0IcgVb93Lt3AL4syvq8bTLttNDUeZK\nxuku796uKb4E/CttXtA1HwCoudjnrg507JiHcCL4gIE2jHcUKy+fOdpJr0EM\nPFMdhfSbcovrcskEv/jO/1acklZWxHvPWCqlDGs/NnjyWHEWVzpdbcahU18t\ntLoQVgWjsbtYkMOa9s9+AD32795bbT0LBLAtss0azIaTb1hVKDF0OqaS3B92\n7baN\r\n=zXB6\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIAfvEza8KsE1RjeICZZxl2S5jNts/+CnY8zFOmh00vbvAiAE8vjHai2aLksaSD3GnGxHHUs9uzjvT2ZXha/G4m9Viw=="}]},"_npmUser":{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"},"directories":{},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/prettier-sql_5.0.0-beta.1_1637016930257_0.46563714385493626"},"_hasShrinkwrap":false},"5.0.0":{"name":"prettier-sql","version":"5.0.0","description":"Format whitespace in a SQL query to make it more readable","license":"MIT","main":"lib/index.js","module":"dist/prettier-sql.min.js","types":"lib/index.d.ts","bin":{"prettier-sql":"bin/prettier-sql-cli.js"},"keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"contributors":[{"name":"Sean Song","email":"mail@seansong.dev"}],"scripts":{"clean":"rimraf lib dist coverage","lint":"eslint .","pretty":"prettier --write .","fix":"npm run pretty && eslint --fix .","pretty:check":"prettier --check .","test":"jest","test:watch":"npm run test -- --watch","check":"npm run pretty:check && npm run lint && npm run test","prepare":"npm run clean && npm run fix && npm run check && npm run build","build:commonjs":"babel src --out-dir lib --extensions .ts --source-maps && tsc --module commonjs --emitDeclarationOnly --isolatedModules","build:umd":"webpack --config webpack.dev.js","build:umd:min":"webpack --config webpack.prod.js","build":"npm run build:commonjs && npm run build:umd && npm run build:umd:min"},"pre-commit":["fix"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"dependencies":{"argparse":"^2.0.1"},"devDependencies":{"@babel/cli":"^7.10.4","@babel/core":"^7.10.4","@babel/plugin-proposal-class-properties":"^7.10.4","@babel/preset-env":"^7.10.4","@babel/preset-typescript":"^7.15.0","@types/babel__core":"^7.1.15","@typescript-eslint/eslint-plugin":"^4.31.2","@typescript-eslint/parser":"^4.32.0","babel-eslint":"^10.1.0","babel-jest":"^26.1.0","babel-loader":"^8.1.0","babel-plugin-add-module-exports":"^1.0.2","dedent-js":"^1.0.1","eslint":"^7.4.0","eslint-config-airbnb-base":"^14.2.0","eslint-config-airbnb-typescript":"^14.0.0","eslint-config-prettier":"^6.11.0","eslint-plugin-import":"^2.22.0","eslint-plugin-prettier":"^3.1.4","jest":"^26.1.0","pre-commit":"^1.2.2","prettier":"^2.0.5","release-it":"^14.11.7","rimraf":"^3.0.2","ts-loader":"^9.2.6","typescript":"^4.3.5","webpack":"^5.64.1","webpack-cli":"^4.9.1","webpack-merge":"^5.8.0"},"jest":{"roots":["test"],"testRegex":".*Test","collectCoverage":true},"gitHead":"63c05eb4e0f18c6380ce71757702e8e4388b4d9f","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","_id":"prettier-sql@5.0.0","_nodeVersion":"14.17.0","_npmVersion":"6.14.13","dist":{"integrity":"sha512-pwcEqqzZZwkB2BhkZOAxdwWsW6+SvieUcGEo0rnvHcw9E55yYUKsqNq3oEBP73En9RpqB+TdNebYGkdL+zy7dg==","shasum":"12235c7f72c287ef0df9c56bd11f9369b9fc2ba3","tarball":"https://registry.npmjs.org/prettier-sql/-/prettier-sql-5.0.0.tgz","fileCount":71,"unpackedSize":2002793,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhnvtRCRA9TVsSAnZWagAApUYP/RzVrj0DYGl2h+NoPkXI\n7Ptnbmvex6k7wB6i0JIN6sYN83KHL0Qx4NjVW5xvaWE2p0aiKJh90/NVDskE\ncjGH4pOPii7ahlAczh9d+7Ut6p1M3JDuTT9gpuvktvoLNDMmzT8d9RMZ1qgr\njigEKwHoO6g+SnMAo36Y12/ICliyvy90dOLF1OxzxdG0AWgLxMFx4kKluhoO\nQrwJrcOaErpwQSOGlVC6Hvyz9A4r2c3c4CaLE6P662eIa0RJdDeDRuHAlYga\niBN91/SOIQbJvGeOxi3/5QNT4oP0SpXmTjKdp1t33c5VsvsDnV38ABmKNrzn\nYafCdv4GQFxxFWRJICzwdd3NKGsCv7d0ibD3Bl7ZPTRP8Vh6UWGk3WdoG162\nJzo8KkDHykIoFvsgFkLyiWO+r5ndMSCFWlBA8/2DS1713Z3rpMD07aKF4bnx\n0p9T4CFQDcylKwgWCHiUCvcDmK+bvN1rOaVCK1FcLC2Y426HSNMKhmdv64yB\n+e0HPTXW3LfECXbLgwkmJBtKtBhkEFdXS/m/BOe/g2HhZTaHrsXyZ4OevADH\ntcb+QRl6obHyqOB4B1SruKL6f6yud4yB02yUe3RoBC4Wnm5czCuekB0Bqf0s\nkOPROz0yOeUMyY47Afm+IyLyy+M04wGUN7BKQpEfN4AbQ/JPPk5ypMK4ajId\nmhTt\r\n=8j6l\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIFx3qSVu7D3Mv5Qw+bfdM0N5tcnhlb+0xhdmFyu7v/uKAiBr/JTcbRUreFnDokbm8G4q+c+0d172bjaEpfvJUm95Ng=="}]},"_npmUser":{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"},"directories":{},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/prettier-sql_5.0.0_1637808977691_0.18019731876388811"},"_hasShrinkwrap":false},"5.0.1":{"name":"prettier-sql","version":"5.0.1","description":"Format whitespace in a SQL query to make it more readable","license":"MIT","main":"lib/index.js","module":"dist/prettier-sql.min.js","types":"lib/index.d.ts","bin":{"prettier-sql":"bin/prettier-sql-cli.js"},"keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"contributors":[{"name":"Sean Song","email":"mail@seansong.dev"}],"scripts":{"clean":"rimraf lib dist coverage","lint":"eslint .","pretty":"prettier --write .","fix":"npm run pretty && eslint --fix .","pretty:check":"prettier --check .","test":"jest","test:watch":"npm run test -- --watch","check":"npm run pretty:check && npm run lint && npm run test","prepare":"npm run clean && npm run fix && npm run check && npm run build","build:commonjs":"babel src --out-dir lib --extensions .ts --source-maps && tsc --module commonjs --emitDeclarationOnly --isolatedModules","build:umd":"webpack --config webpack.dev.js","build:umd:min":"webpack --config webpack.prod.js","build":"npm run build:commonjs && npm run build:umd && npm run build:umd:min"},"pre-commit":["fix"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"dependencies":{"argparse":"^2.0.1"},"devDependencies":{"@babel/cli":"^7.10.4","@babel/core":"^7.10.4","@babel/plugin-proposal-class-properties":"^7.10.4","@babel/preset-env":"^7.10.4","@babel/preset-typescript":"^7.15.0","@types/babel__core":"^7.1.15","@typescript-eslint/eslint-plugin":"^4.31.2","@typescript-eslint/parser":"^4.32.0","babel-eslint":"^10.1.0","babel-jest":"^26.1.0","babel-loader":"^8.1.0","babel-plugin-add-module-exports":"^1.0.2","dedent-js":"^1.0.1","eslint":"^7.4.0","eslint-config-airbnb-base":"^14.2.0","eslint-config-airbnb-typescript":"^14.0.0","eslint-config-prettier":"^6.11.0","eslint-plugin-import":"^2.22.0","eslint-plugin-prettier":"^3.1.4","jest":"^26.1.0","pre-commit":"^1.2.2","prettier":"^2.0.5","release-it":"^14.11.7","rimraf":"^3.0.2","ts-loader":"^9.2.6","typescript":"^4.3.5","webpack":"^5.64.1","webpack-cli":"^4.9.1","webpack-merge":"^5.8.0"},"jest":{"roots":["test"],"testRegex":".*Test","collectCoverage":true},"gitHead":"45d4dd223a2bee39024d6de5fb4bb7d8db75c7e6","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","_id":"prettier-sql@5.0.1","_nodeVersion":"14.17.0","_npmVersion":"6.14.13","dist":{"integrity":"sha512-bjcOltr044ktVM4UUr7Vi0V4wJlk1Uke9ONS8VU6ekee/2GsDw8EpYmOjZjPqGzO0tsthj8QizzmiLmn3GnJFA==","shasum":"6434953e7e20c279a6fe2abce64a7f7488fcc7c9","tarball":"https://registry.npmjs.org/prettier-sql/-/prettier-sql-5.0.1.tgz","fileCount":71,"unpackedSize":2006928,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhnx7dCRA9TVsSAnZWagAAGtgP/1vogp5epgaYMU/y0Cz4\nT2mkZSmi2sh9kFYWldio/Q/gcKWTbhr01Fu7WS8DXcoSDgC97ybqwLJ6ruEg\n/bkiZGptIzZNiyg7njT3knws65ImIHr2N9RkQ6in8pF7ac5qAxOLZfwp37jK\nijdhS0QgFhHqP5qB7GVsftwf/FiJaLxsp8jMsE+XYuc1/c5Nz6EcxnSo5rcO\n2hgtpWZbLs6UJeq80dDRecmPQ6ReUUtqFMwpyClwseWb3RHhGDvJXb0HX5oh\nW+KseyYWHy/avsJeQaVEFUl6YWxeURnUez3JhC6H8qwmhdts/vi3zu6xxlgC\noTEkbU3zEsbnmx5H70YTYxfYFY0G+rbUJASD3qs0ZgxKcFIZn6mM40WOJYS7\nnAeTm4aKOh2d4+m7hlSZpoBJGmwjs7T/bb36bJMKa6S2f5yLTDvjZiiJ9165\nvCGVVjx7gTCxXIUaOsUWDXJXpXUYQD66b2BFQ7FpK3y7AkG+XiOQSU4lI1eO\nJb0J9r9i1hJqbzMnn7V8OILGJwv9lROmjmhV6JV2XxkMWE5xo7dWBZD4Nj/D\n4NkV8BKQw3xaWDUivJmgqhjIzfT8woo40Qyi4i7/SWs1U8OTRia1NG1XZaKn\nCtewf5kAYfah4PHPhWh2ZjdWtTYVyZ3uFBkfkdJya5JgPl3oBwPomxRWFlFf\n5agB\r\n=vv5O\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEQCIBAJOMIYYPwnSkogN/RCjFaohtgRdnoyQaPPWQcTrDR3AiBxkzp2zYzTE+fwUtnzLP6xq9D7LbeUdFf+gt8+6U2Q3Q=="}]},"_npmUser":{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"},"directories":{},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/prettier-sql_5.0.1_1637818076865_0.4894160791343376"},"_hasShrinkwrap":false},"5.1.0":{"name":"prettier-sql","version":"5.1.0","description":"Format whitespace in a SQL query to make it more readable","license":"MIT","main":"lib/index.js","module":"dist/prettier-sql.min.js","types":"lib/index.d.ts","bin":{"prettier-sql":"bin/prettier-sql-cli.js"},"keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"contributors":[{"name":"Sean Song","email":"mail@seansong.dev"}],"scripts":{"clean":"rimraf lib dist coverage","lint":"eslint .","pretty":"prettier --write .","fix":"npm run pretty && eslint --fix .","pretty:check":"prettier --check .","test":"jest","test:watch":"npm run test -- --watch","check":"npm run pretty:check && npm run lint && npm run test","prepare":"npm run clean && npm run fix && npm run check && npm run build","build:commonjs":"babel src --out-dir lib --extensions .ts --source-maps && tsc --module commonjs --emitDeclarationOnly --isolatedModules","build:umd":"webpack --config webpack.dev.js","build:umd:min":"webpack --config webpack.prod.js","build":"npm run build:commonjs && npm run build:umd && npm run build:umd:min"},"pre-commit":["fix"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"dependencies":{"argparse":"^2.0.1"},"devDependencies":{"@babel/cli":"^7.10.4","@babel/core":"^7.10.4","@babel/plugin-proposal-class-properties":"^7.10.4","@babel/preset-env":"^7.10.4","@babel/preset-typescript":"^7.15.0","@types/babel__core":"^7.1.15","@typescript-eslint/eslint-plugin":"^4.31.2","@typescript-eslint/parser":"^4.32.0","babel-eslint":"^10.1.0","babel-jest":"^26.1.0","babel-loader":"^8.1.0","babel-plugin-add-module-exports":"^1.0.2","dedent-js":"^1.0.1","eslint":"^7.4.0","eslint-config-airbnb-base":"^14.2.0","eslint-config-airbnb-typescript":"^14.0.0","eslint-config-prettier":"^6.11.0","eslint-plugin-import":"^2.22.0","eslint-plugin-prettier":"^3.1.4","jest":"^26.1.0","pre-commit":"^1.2.2","prettier":"^2.0.5","release-it":"^14.11.7","rimraf":"^3.0.2","ts-loader":"^9.2.6","typescript":"^4.3.5","webpack":"^5.64.1","webpack-cli":"^4.9.1","webpack-merge":"^5.8.0"},"jest":{"roots":["test"],"collectCoverage":true},"gitHead":"538ad0510e40496201987a8f981e6648ee73f8fd","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","_id":"prettier-sql@5.1.0","_nodeVersion":"14.17.0","_npmVersion":"6.14.13","dist":{"integrity":"sha512-85IvpNNDhECsIjb7rImLo5JIIcwssgx63NPbnlEUtsjHMN28Aik8xmFYLXesq09oGS3KX7COfINmKttVPvRrCw==","shasum":"cb5dcea3904ff628abf7ebf1ca61a4c1eb7779d3","tarball":"https://registry.npmjs.org/prettier-sql/-/prettier-sql-5.1.0.tgz","fileCount":77,"unpackedSize":2287119,"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v3.0.13\r\nComment: https://openpgpjs.org\r\n\r\nwsFcBAEBCAAQBQJhxQMHCRA9TVsSAnZWagAAC3AP/2kR0qp3SUv1QuYGaOgA\nV9mrQ/kHI747tfPBZZclI2eX8WK3NgVIzGKgwUfdX9ToHxKrTsjHpl/h5Vq+\nHn9hTzkHGazPyRdrjulKnfy2QvMnL0DSarNSA3ledzaH9W5bJAayRemHc+OR\n1rOtHBWHpH+NLDzy4ObRUVfLwp7tTD6DfymJXEqium/PMgl1UjCZsOg8YEui\nVsS6VtsqdY/2u+GLgjBiEIixUIpJlvsTkr6/q13oWlXyEoVxgx6W788LIjRU\nrOyIrtd7H25rKvPW40zF8OpiWbXHiImnmdLxBSGEV31hR5R0F1HuDgplQQWN\n6+TOKxcRix9NC2YzsAhuYqwvrFPPOWFTnwYx+sSh+Q3nag1HixhMGX6FI+qE\nMlR4YblhOG0YHA9JjZVHJRVZ/RwKVmF5NujhAXhzm0ndCGcx7M8Sk6QDuX9a\nOcF5R8YsaYxirP+qvdj0IfxqdKWodNRlaxhwP4ICcNjJpQNmxM+RlNH50lL9\nz7BJPJTRKnlDSYUOg+E5C7oS6jBofGvdiQFeeTRKH//Ocg10NeKKFbWjSpID\n1QKgid6aOXeAwHWwlzwpjNYfaqGSQtGeqYD2DjdNNeolA2s4BrwSCi+7n85H\nCdC2M0zhm5CmBb24sRZY/NxaDGb1C+N/9E8TLINgj5Gq8EuHvU496SHVlcpB\nPKua\r\n=DDdj\r\n-----END PGP SIGNATURE-----\r\n","signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIHm0nKw6X+bYKCCR8IkW0eWugem/ejHZDptNnYqG8UYEAiEAx2O5xpdQ14hZPYCXxy83PEGJU8gFUJUFpro/7GDIsRY="}]},"_npmUser":{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"},"directories":{},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/prettier-sql_5.1.0_1640301318821_0.8884375024738427"},"_hasShrinkwrap":false},"5.1.1":{"name":"prettier-sql","version":"5.1.1","description":"Format whitespace in a SQL query to make it more readable","license":"MIT","main":"lib/index.js","module":"dist/prettier-sql.min.js","types":"lib/index.d.ts","bin":{"prettier-sql":"bin/prettier-sql-cli.js"},"keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"contributors":[{"name":"Sean Song","email":"mail@seansong.dev"}],"scripts":{"clean":"rimraf lib dist coverage","lint":"eslint .","pretty":"prettier --write .","fix":"npm run pretty && eslint --fix .","pretty:check":"prettier --check .","test":"jest","test:watch":"npm run test -- --watch","check":"npm run pretty:check && npm run lint && npm run test","prepare":"npm run clean && npm run fix && npm run check && npm run build","build:commonjs":"babel src --out-dir lib --extensions .ts --source-maps && tsc --module commonjs --emitDeclarationOnly --isolatedModules","build:umd":"webpack --config webpack.dev.js","build:umd:min":"webpack --config webpack.prod.js","build":"npm run build:commonjs && npm run build:umd && npm run build:umd:min"},"pre-commit":["fix"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"dependencies":{"argparse":"^2.0.1"},"devDependencies":{"@babel/cli":"^7.10.4","@babel/core":"^7.10.4","@babel/plugin-proposal-class-properties":"^7.10.4","@babel/preset-env":"^7.10.4","@babel/preset-typescript":"^7.15.0","@jest/globals":"^27.5.1","@types/babel__core":"^7.1.15","@typescript-eslint/eslint-plugin":"^4.31.2","@typescript-eslint/parser":"^4.32.0","babel-eslint":"^10.1.0","babel-jest":"^26.1.0","babel-loader":"^8.1.0","babel-plugin-add-module-exports":"^1.0.2","dedent-js":"^1.0.1","eslint":"^7.4.0","eslint-config-airbnb-base":"^14.2.0","eslint-config-airbnb-typescript":"^14.0.0","eslint-config-prettier":"^6.11.0","eslint-plugin-import":"^2.22.0","eslint-plugin-prettier":"^3.1.4","jest":"^26.1.0","pre-commit":"^1.2.2","prettier":"^2.0.5","release-it":"^14.11.7","rimraf":"^3.0.2","ts-loader":"^9.2.6","typescript":"^4.3.5","webpack":"^5.64.1","webpack-cli":"^4.9.1","webpack-merge":"^5.8.0"},"jest":{"roots":["test"],"collectCoverage":true},"gitHead":"a08aef466b12618e52e34e967f2ece18da2c42c2","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","_id":"prettier-sql@5.1.1","_nodeVersion":"14.17.0","_npmVersion":"6.14.13","dist":{"integrity":"sha512-LBktl+zf8ClZTsbPGbK+5a3khsmsKdYbR1keOq1J2oGCzAXP64m27ZBnuWBFDLXV10i6xTfClV+nT9ecH8PMiA==","shasum":"48bb66a10858d13d478bfc693a19f31260a7d44f","tarball":"https://registry.npmjs.org/prettier-sql/-/prettier-sql-5.1.1.tgz","fileCount":77,"unpackedSize":2375157,"signatures":[{"keyid":"SHA256:jl3bwswu80PjjokCgh0o2w5c2U4LhQAE57gj9cz1kzA","sig":"MEUCIQCmGMiXdcMJOR6ezIgnw05niyjAuVoYhH09+ZyX/ChHCwIgKhG/Yv1VJMTQ44eH8DH4qjY0tT4HTe29UuRKIeF7Av4="}],"npm-signature":"-----BEGIN PGP SIGNATURE-----\r\nVersion: OpenPGP.js v4.10.10\r\nComment: https://openpgpjs.org\r\n\r\nwsFzBAEBCAAGBQJiUZZ/ACEJED1NWxICdlZqFiEECWMYAoorWMhJKdjhPU1b\r\nEgJ2Vmre/g/9G2h5HXV2doJmHgJoqxoXMm36XRzXTAsYgXUYHFfEGQpvlcCB\r\nyheDtpdMppO+8VN/XYJs8DHHW/oIQPBW4xY16v1Hdbk8tN3b5cJsbe17ap0A\r\nGTZquQtTufQKBldkt/CUZ1F/0t1lsHRaIs1ZjMBsVhv3JIiEpuLVkFuOX4de\r\nebWVrqSf5mC2LKzbqcJRJ8LPzzoNSS3NfUNPDnFyznxukV7LhmGwn3zIUBu9\r\n+uPodXoYacljjnI8G5c1ywpzzXqe9WYuBFaCW0itP1BsAfWIEgVUJBLyc6tk\r\nQgGsnEAmWlxJRtcfEfnhmlWWF7LMBZNSXOKtlRcj3TsdxbZqRxfDlY0gWzqV\r\n25uLBm/U+YerRcBTZn+j7LANYD3jxc4rWAI8g5R7HIg8bANY9LDbqCG6uSRO\r\nzqyGoxEjObS5yVEofYzi1+lGe/ls7eM+TBdEJm+KV0PEGYHGodTWXL/k+arR\r\nZ8CEFgnjyd4w7JNqJjZBp91Hp+42oT/EajrzIKG5RHVqI289rvxcMPjYGLRH\r\n6zf71+0W7pjbKntre8nZvsuvCejWs4b7HSVpcduaJVfyc2IMJ9FUFK4PC8ei\r\njc8aCMszsvvTGz9BBedqIy9Rtj0LhKUXhreKcN51rEwagHrASDJ39ffDw/ga\r\nwDcHgldZEXpin97SHH7Kzop5rJy7CHanqpo=\r\n=t2Pr\r\n-----END PGP SIGNATURE-----\r\n"},"_npmUser":{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"},"directories":{},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"_npmOperationalInternal":{"host":"s3://npm-registry-packages","tmp":"tmp/prettier-sql_5.1.1_1649514111472_0.713092413966401"},"_hasShrinkwrap":false}},"time":{"created":"2021-11-15T22:55:30.256Z","5.0.0-beta.1":"2021-11-15T22:55:30.432Z","modified":"2022-05-13T09:26:56.246Z","5.0.0":"2021-11-25T02:56:17.903Z","5.0.1":"2021-11-25T05:27:57.064Z","5.1.0":"2021-12-23T23:15:19.015Z","5.1.1":"2022-04-09T14:21:51.672Z"},"maintainers":[{"name":"inferrinizzard","email":"inferrinizzard@gmail.com"}],"description":"Format whitespace in a SQL query to make it more readable","homepage":"https://github.com/inferrinizzard/prettier-sql#readme","keywords":["sql","formatter","format","n1ql","redshift","spark","whitespace","mysql","mariadb","postgresql","pl/sql","transact-sql","db2"],"repository":{"type":"git","url":"git+https://github.com/inferrinizzard/prettier-sql.git"},"contributors":[{"name":"Sean Song","email":"mail@seansong.dev"}],"bugs":{"url":"https://github.com/inferrinizzard/prettier-sql/issues"},"license":"MIT","readme":"\n\n# Prettier SQL [![NPM version](https://img.shields.io/npm/v/prettier-sql.svg)](https://npmjs.com/package/prettier-sql) ![GitHub Workflow Status (event)](https://img.shields.io/github/workflow/status/inferrinizzard/prettier-sql/coveralls/master?label=Build&logo=Github) ![Coveralls](https://img.shields.io/coveralls/github/inferrinizzard/prettier-sql?branch=master&label=Coverage&logo=coveralls&style=plastic) [![VSCode](https://img.shields.io/visual-studio-marketplace/v/inferrinizzard.prettier-sql-vscode?label=vscode)](https://marketplace.visualstudio.com/items?itemName=inferrinizzard.prettier-sql-vscode)\n\n## **Prettier SQL** is a JavaScript library for pretty-printing SQL queries.\n\nIt started as a port of a [PHP Library][], but has since considerably diverged.\n\nPrettier SQL supports the following dialects:\n\n- **sql** - [Standard SQL][]\n- **bigquery** - [GCP BigQuery][]\n- **db2** - [IBM DB2][]\n- **hive** - [Apache Hive][]\n- **mariadb** - [MariaDB][]\n- **mysql** - [MySQL][]\n- **n1ql** - [Couchbase N1QL][]\n- **plsql** - [Oracle PL/SQL][]\n- **postgresql** - [PostgreSQL][]\n- **redshift** - [Amazon Redshift][]\n- **spark** - [Spark][]\n- **tsql** - [SQL Server Transact-SQL][tsql]\n\nIt does not support:\n\n- Stored procedures.\n- Changing of the delimiter type to something else than `;`.\n\n→ [Try the demo.](https://inferrinizzard.github.io/prettier-sql)\n\n# Table of contents\n\n- [Install](#install)\n- [Documentation](#documentation)\n- [Usage](#usage)\n - [Usage as library](#usage-as-library)\n - [Usage from command line](#usage-from-command-line)\n - [Usage without NPM](#usage-without-npm)\n - [Usage with VSCode](#usage-with-vscode)\n- [Contributing](#contributing)\n\n## Install\n\nGet the latest version from NPM:\n\n```sh\nnpm install prettier-sql\n```\n\nAlso available with yarn:\n\n```sh\nyarn add prettier-sql\n```\n\n## Documentation\n\nYou can read more about how the library works in [DOC.md](DOC.md)\n\n## Usage\n\n### Usage as library\n\n```js\nimport { format } from 'prettier-sql';\n\nconsole.log(format('SELECT * FROM tbl'));\n```\n\nThis will output:\n\n```sql\nSELECT\n *\nFROM\n tbl\n```\n\nYou can also pass in configuration options:\n\n```js\nformat('SELECT * FROM tbl', {\n\tlanguage: 'spark', // Defaults to \"sql\" (see the above list of supported dialects)\n\tindent: ' ', // Defaults to two spaces\n\tuppercase: false, // Defaults to true\n\tlinesBetweenQueries: 2, // Defaults to 1\n});\n```\n\n### Placeholders replacement\n\n```js\n// Named placeholders\nformat(\"SELECT * FROM tbl WHERE foo = @foo\", {\n params: {foo: \"'bar'\"}\n}));\n\n// Indexed placeholders\nformat(\"SELECT * FROM tbl WHERE foo = ?\", {\n params: [\"'bar'\"]\n}));\n```\n\nBoth result in:\n\n```sql\nSELECT\n *\nFROM\n tbl\nWHERE\n foo = 'bar'\n```\n\n### Usage from command line\n\nThe CLI tool will be installed under `prettier-sql`\nand may be invoked via `npx prettier-sql`:\n\n```sh\nprettier-sql -h\n```\n\n```\nusage: sqlfmt.js [-h] [-o OUTPUT] \\\n[-l {bigquery,db2,hive,mariadb,mysql,n1ql,plsql,postgresql,redshift,spark,sql,tsql}] [-c CONFIG] [--version] [FILE]\n\nPrettier SQL\n\npositional arguments:\n FILE Input SQL file (defaults to stdin)\n\noptional arguments:\n -h, --help show this help message and exit\n -o, --output OUTPUT\n File to write SQL output (defaults to stdout)\n -l, --language {bigquery,db2,hive,mariadb,mysql,n1ql,plsql,postgresql,redshift,spark,sql,tsql}\n SQL dialect (defaults to standard sql)\n -c, --config CONFIG\n Path to config json file (will use default configs if unspecified)\n --version show program's version number and exit\n```\n\nBy default, the tool takes queries from stdin and processes them to stdout but\none can also name an input file name or use the `--output` option.\n\n```sh\necho 'select * from tbl where id = 3' | prettier-sql\n```\n\n```sql\nSELECT\n *\nFROM\n tbl\nWHERE\n id = 3\n```\n\nThe tool also accepts a JSON config file with the `--config` option that takes this form: \\\nAll fields are optional and all fields that are not specified will be filled with their default values\n\n```ts\n{\n\t\"indent\": string,\n\t\"uppercase\": boolean,\n\t\"keywordPosition\": \"standard\" | \"tenSpaceLeft\" | \"tenSpaceRight\",\n\t\"newline\": \"always\" | \"lineWidth\" | \"never\" | number,\n\t\"breakBeforeBooleanOperator\": boolean,\n\t\"aliasAs\": \"always\" | \"select\" | \"never\",\n\t\"tabulateAlias\": boolean,\n\t\"commaPosition\": \"before\" | \"after\" | \"tabular\",\n\t\"parenOptions\": {\n\t\t\"openParenNewline\": boolean,\n\t\t\"closeParenNewline\": boolean\n\t},\n\t\"lineWidth\": number,\n\t\"linesBetweenQueries\": number,\n\t\"denseOperators\": boolean,\n\t\"semicolonNewline\": boolean,\n}\n```\n\n### Usage without NPM\n\nIf you don't use a module bundler, clone the repository, run `npm install` and grab a file from `/dist` directory to use inside a `