`@dr666m1/prettier-plugin-bq` is a [prettier](https://prettier.io/) plugin for **standardSQL**, which is a dialect of BigQuery.
npm install @dr666m1/prettier-plugin-bq@dr666m1/prettier-plugin-bq is a prettier plugin for standardSQL, which is a dialect of BigQuery.⚠️ This plugin is still a work in progress, so the behavior would change frequently.
npm install --save-dev --save-exact prettier @dr666m1/prettier-plugin-bq
`Usage
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
`For more information, please read the prettier document.
Configuration
Below are the options that @dr666m1/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.|