Prettier-plugin-bq NPM

prettier-plugin-bq

prettier-plugin-bq is a prettier plugin for GoogleSQL, which is a dialect of BigQuery.

npm install --save-dev --save-exact prettier prettier-plugin-bq

As the prettier document says, the plugin is automatically loaded.

Plugins are automatically loaded if you have them installed in the same node_modules directory where prettier is located.

You can format .sql and .bq file by the following command.

npx prettier --write ./xxx.sql --plugin=prettier-plugin-bq

For more information, please read the prettier document.

Below are the options that prettier-plugin-bq currently supports.

API Option	CLI Option	Default	Description
formatMultilineComment	format-multiline-comment	false	(experimental) Print multiline commnets in "starred-block" style.
indentCte	indent-cte	true	Indent CTEs in with clause.
printBlankLineAfterCte	print-blank-line-after-cte	false	Print blank line after CTE in with clause.
printKeywordsInUpperCase	print-keywords-in-upper-case	true	Print reserved keywords and functions in upper case.
printPseudoColumnsInUpperCase	print-pseudo-columns-in-upper-case	true	Print pseudo columns (e.g. `_PARTITIONDATE`, `_PARTITIONTIME`) in upper case. When `printKeywordsInUpperCase` is `false`, this option is ignored.