sql-formatter - npm Package Compare versions

Comparing version 12.0.0-beta.2 to 12.0.0-beta.3

lib/languages/trino/trino.formatter.js

@@ -56,3 +56,3 @@ import { expandPhrases } from '../../expandPhrases.js';
     },
-    operators: ['%', '->', ':', '||', // Row pattern syntax
+    operators: ['%', '->', '=>', ':', '||', // Row pattern syntax
     '|', '^', '$' // '?', conflicts with positional placeholders
@@ -59,0 +59,0 @@ ]

package.json

 {
   "name": "sql-formatter",
-  "version": "12.0.0-beta.2",
+  "version": "12.0.0-beta.3",
   "description": "Format whitespace in a SQL query to make it more readable",
@@ -71,2 +71,3 @@ "license": "MIT",
     "Olexandr Sydorchuk <[e-mail]>",
+    "Pavel Djundik <[e-mail]>",
     "Rafael Pinto <[e-mail]>",
@@ -73,0 +74,0 @@ "Rahel Rjadnev-Meristo <[e-mail]>",

README.md

@@ -41,3 +41,3 @@ <a href='https://github.com/sql-formatter-org/sql-formatter'><img src="static/prettier-sql-clean.svg" width="128"/></a>
 
-console.log(format('SELECT * FROM tbl'));
+console.log(format('SELECT * FROM tbl', { language: 'mysql' }));
 ```
@@ -154,4 +154,4 @@
 - [**`logicalOperatorNewline`**](docs/logicalOperatorNewline.md) newline before or after boolean operator (AND, OR, XOR).
-- [**`tabulateAlias`**](docs/tabulateAlias.md) aligns column aliases vertically.
-- [**`commaPosition`**](docs/commaPosition.md) where to place the comma in column lists.
+- [**`tabulateAlias`**](docs/tabulateAlias.md) aligns column aliases vertically (**unstable!**).
+- [**`commaPosition`**](docs/commaPosition.md) where to place the comma in column lists (**unstable!**).
 - [**`expressionWidth`**](docs/expressionWidth.md) maximum number of characters in parenthesized expressions to be kept on single line.
@@ -175,2 +175,22 @@ - [**`linesBetweenQueries`**](docs/linesBetweenQueries.md) how many newlines to insert between queries.
 
+## Frequently Asked Questions
+
+### Parse error: Unexpected ... at line ...
+
+The most common cause is that you haven't specified an SQL dialect.
+Instead of calling the library simply:
+
+```js
+format('select [col] from tbl');
+// Throws: Parse error: Unexpected "[col] from" at line 1 column 8
+```
+
+pick the proper dialect, like:
+
+```js
+format('select [col] from tbl', { language: 'transactsql' });
+```
+
+Or when using the VSCode extension: Settings -> Prettier-SQL: SQLFlavourOverride.
+
 ## Contributing
@@ -177,0 +197,0 @@

New alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Fixed alerts

License Policy Violation

License

This package is not allowed per your license policy. Review the package's license to ensure compliance.

Found 1 instance in 1 package

Improved metrics

Total package byte prevSize

2133027

increased by0.03%

Number of lines in readme file

202

increased by10.99%

No dependency changes