sql-formatter

sql-formatter copied to clipboard

[FORMATTING] postgresql timestamp datatype on create table adds unnecessary newline

1

**Input data** Which SQL and options did you provide as input? ```sql create table test ( a int, b int, c TIMESTAMP with time zone, d int ); ``` **Expected...

alarbada

Add paramTypes config option

1

Added new config option `paramTypes` which allows overriding the prepared statement parameter types supported by default. Did some slight restructuring of Tokenizer to allow config options to effect which kind...

nene

Bring back `precedingWhitespace` field to preserve positions of line comments. - When comment was originally at the end of a line, keep it on the line end - When comment...

nene

Feature Request: Extension for Azure Data Studio

1

Would it be possible to create an extension for [Azure Data Studio](https://docs.microsoft.com/en-us/sql/azure-data-studio/download-azure-data-studio) too? I really like how this formatter is shaping up and have been using it regularly. But we...

1nfected

postgresql: better handle DISTINCT clause

4

At present sql-formatter produces: ```sql SELECT DISTINCT ON (c1, c2) c1, c2 FROM t1; ``` But we expect: ```sql SELECT DISTINCT ON (c1, c2) c1, c2 FROM t1; -- or...

holymonson

Formatting issue when using named parameter(Java sql syntax)

6

**Input data** ```sql select supplier_name,city from (select * from suppliers join addresses on suppliers.address_id=addresses.id) as suppliers where supplier_id>:supplier_id order by supplier_name asc,city desc; ``` **Expected Output** ```sql select supplier_name, city...

gauravjhs

Feature Request: user defined formatter

3

**Describe the Feature** I want to be able to define my own language which is a slight modification of an existing language. Something like this ```js import { format, Formatter,...

verhovsky

Feature Request: Add Snowflake as a SQL Dialect

5

**Describe the Feature** The `sql-formatter` currently supports many SQL dialects, including BigQuery and SQL Server. Would it be possible to add Snowflake? **Why do you want this feature?** I use...

gvanstee

That's an initial attempt at replacing our current parser with Nearley. Just trying it out and seeing what kind of problems arise. Discovered several problems: - [x] Case-sensitivity: Nearley matches...

nene

[FORMATTING] Comments move their lines after formatting

5

**Input data** ```sql select name, -- student name age -- student age from students -- ending comment /* another ending comment */ ``` **Expected Output** ```sql select name, -- student...

primeapple