Comments (3)
Thanks for reporting. The problem is with the keyword VALUES
. The same problem happens in this shorter SQL query:
SELECT values.id FROM my_table AS "values"
The formatter expects values
to be the beginning of a VALUES (...)
clause, but here it's used as a table name.
Currently the workaround is to simply quote it.
It's likely something that isn't easy to fix, because it stems from the architectural problems in the formatter.
As you're using PostgreSQL, I can suggest you instead try prettier-plugin-sql-cst, which formats this query just fine. It doesn't yet have full PostgreSQL support, but if you're mainly formatting queries, it should work better than SQL Formatter.
from sql-formatter.
Ah, that makes sense.
It's probably best practice not to use keywords as table names so I think I'll just change the name of that cte :)
from sql-formatter.
I'll close this issue as it's too unlikely that it'll get fixed.
from sql-formatter.
Related Issues (20)
- [FORMATTING] Error when formatting Clickhouse SQL with Array column type HOT 1
- Feature Request: expose parsing apis HOT 3
- Supplying empty regex crashes browser HOT 2
- [VSCODE] `SQL-Formatter-VSCode.expressionWidth` not respected HOT 2
- "Prettier-SQL.tabulateAlias": true ignores back ticks HOT 1
- [FORMATTING] MariaDB function call parenthesis spacing results in invalid MariaDB SQL HOT 5
- [VSCODE] Inconsistent formatting between VSCode extension and CLI HOT 2
- [VSCode] Feature Request: Support JSON config file HOT 1
- [FORMATTING] Missing space after colon in `JSON_OBJECT(key: value)` HOT 1
- [FORMATTING] BigQuery: Doesn't handle escaped quotes in raw strings HOT 1
- Feature Request: Double colon support HOT 1
- Feature Request: Detect dialect inside a comment or filename
- [FORMATTING] problem with line like 'ORDER BY t1.DATE DESC, t1.[%title%] ASC' HOT 8
- Feature Request: Detect / Format parameters included in SQL statement HOT 2
- [FORMATTING] Quotation marks incomplete, formatting error HOT 2
- [FORMATTING] Full text search distance formats `<->` incorrectly HOT 1
- [FORMATTING] Column called "type" in Snowflake HOT 2
- [FORMATTING] Empty lines between comment lines/blocks should be preserved HOT 1
- db2i formatting does not work with JSON* functions HOT 1
- vscode plugin: expose logs to vscode frontend or describe in documentation how to reach the logs HOT 4
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sql-formatter.