Spaces are inserted before/after certain special characters about sql-formatter HOT 10 CLOSED

try this in your tokenizer.js instead of the existing regex function

Tokenizer.prototype.createWordRegex = function createWordRegex() {
    var specialChars = arguments.length > 0 && arguments[0] !== undefined ? arguments[0] : [];

    return new RegExp(`^([A-Za-z\u00C0-\u00D6\u00D8-\u00f6\u00f8-\u00ff` + specialChars.join("") + "]+)");
};

from sql-formatter.

@robbz23, thanks for your effort of writing a patch.

I see that your suggested regex probably comes from this StackOverflow post:

• https://stackoverflow.com/questions/23590257/match-word-characters-including-country-specific-letters-like-%C3%B6%C3%A4%C3%BC

from sql-formatter.

Yup thats the one. I started on a branch for TSQL specifically we are using Sybase and we have very specific formatting requirements. Many of us already use VS Code so I thought your library was a perfect fit. I will submit my code when I get it working well.

from sql-formatter.

Hey, I'm using a PostgreSQL database and got the same Issue when formating parameterized queries like:

SELECT * FROM people WHERE last_name = $1

this ends up in

SELECT
  *
FROM
  people
WHERE
  first_name = $ 1

from sql-formatter.

I have a query with Big Query's REGEXP_CONTAINS
like this

SELECT field1 FROM table1 WHERE REGEXP_CONTAINS(field1, r"value")

then after format it turns to

SELECT
  field1
FROM
  table1
WHERE
  REGEXP_CONTAINS(field1, r "value")

there is a space between r and "value" which break the query.

from sql-formatter.

@nene any progress on this one?

Most operators are formatted so they have separating space in the middle.

Some references:
https://www.postgresql.org/docs/10/functions-textsearch.html
https://www.postgresql.org/docs/9.6/functions-array.html

I guess these operators could be added in tokenizer regexp https://github.com/zeroturnaround/sql-formatter/blob/master/src/core/Tokenizer.js#L22

from sql-formatter.

Fixed now in 3.1.0 release

from sql-formatter.

Query columns with special characters not working..

I have a below query and is valid query with column names with some special characters like #, $ etc

Select a#
 from b

Now when I format this query it get white space between special character and name. e.g
Select a # from b
which makes it invalid query. As column name is a#

is there a way we can allow special characters in query or format ignore while formatting so query remains valid. I am using N1QL

from sql-formatter.

Im having the same issue where sql formater <@ to < @ causing query to break

from sql-formatter.

@MariuzM Please open another issue. Also make sure you have selected the right SQL dialect (I guess you're using PostgreSQL, and that's not the default).

from sql-formatter.