sql-formatter

sql-formatter copied to clipboard

Hi there, I tested the demo of sql-formatter, https://sql-formatter-org.github.io/sql-formatter/ There is an option "Indentation style: Tabular, Right", is there any way of veritcal-blank edition to archive this? Many thanks.

AndyGeng123

Named placeholders are broken due to whitespace

3

Name placeholders like `WHERE name = :name` are broken and do not replace at all. Example: ```sql SELECT supplier_name, city FROM suppliers WHERE supplier_id = :name ``` this formats as:...

michaelborn

I know this is a *SQL Formatter*, but can it also be used to **extract** table names from a SQL Statement! Previously I have worked with: * SQL Table Name...

goranschwarz

Extra whitespace inserted in string concatenation operator

3

In Dialect.PostgreSql, when using the string concatenation operator (||), extra whitespace is inserted. ```kotlin val res = SqlFormatter .of(Dialect.PostgreSql) .format("select aa || bb from zzz") println(res) // select // aa...

rhinotake

I'm specially interested in the following questions: 1. anyway to convert keywords to upper case?

dclong

Formatting issue after LIKE Predicate Escape Character '\'

3

This only seems to happen when using '\' as the escape character. I've tired all the supported languages using the of(...) with the same results. I've provide a simple sample...

Darphbobo1573

Date query parameters do not come out quoted, and don't use the standard ISO format accepted by most DB platforms.

muhmud

Escape character + escaped double quote makes formatted SQL invalid

2

In Postgres such a query is valid: ``` select A as "A\""B" from "T1"; ``` The single result column will be named `A\"B`. The backslash escape isn't used as escape...

jzillmann

With this new config parameter you are able to skip white spaces before and after block parentheses. For example Without this parameter: CREATE VIEW sakila.v_exampl (customer, phone, title) AS select...

hemlac

A space is created as shown in the example below. ``` @Test void test() { String sql = "SELECT * FROM TEST WHERE ABC != '4'"; String format = SqlFormatter.format(sql);...

ddakker