sqlformat-rs
sqlformat-rs copied to clipboard
shssoichiro
SQL Formatter written in Rust
Would you be willing to release binaries for a CLI for this via Github Releases? I'm not sure what other projects are using, but this looks like it may work:...
The current behaviour: ```sql INSERT INTO users (name, email) VALUES ($1, $2) RETURNING name, email ``` Would be better as: ```sql INSERT INTO users (name, email) VALUES ($1, $2) RETURNING...
Current formatting: ```sql INSERT INTO users (name, email) VALUES ($1, $2) ON CONFLICT (email) DO UPDATE SET name = $1 ``` Proposed: ```sql INSERT INTO users (name, email) VALUES ($1,...
A small issue from https://github.com/PRQL/prql/issues/4299 ```sql SELECT table_0.* EXCEPT (profit), details.* EXCEPT (item_id), table_0.profit FROM table_0 ``` is formatted as ```sql SELECT table_0.* EXCEPT (profit), details.* EXCEPT (item_id), table_0.profit FROM...
We use ClickHouse & it doesn't like `STRING`, it prefers `String`. It would be nice if we there was an ignore keyword list for uppercase.
`CREATE TABLE a (b integer references c (id) on update restrict, other integer)` results in ``` CREATE TABLE a ( b integer REFERENCES c (id) ON UPDATE RESTRICT, other integer...
Thanks for this tool! What I'm looking is something similar to `--sqlformat-ignore` cooment that ignores the next line. I'm trying to have a column named as "password", but it is...
PostgreSQL provide a special syntax for a one-byte character `E'`' sqlformat puts space after `E` which is incorrect ``` $ echo "SELECT 'new line -> '||E'\n';" | sleek SELECT 'new...
Piggy backing off : https://github.com/nrempel/sleek/issues/16 If `uppercase` is `false`, the query is not lowercased. Either there should be an explicit flag to lowercase the query, or `uppercase = false` should...
Firstly thanks for the awesome library. We use it in https://github.com/prql/prql to format SQL once our compiler has produced it, from sqlparser-rs. A couple of times we've wanted to _not_...