[FORMATTING] problem with line like 'ORDER BY t1.DATE DESC, t1.[%title%] ASC'

[Aliaksandr3by]

ORDER BY t1.DATE DESC, t1.[%title%] ASC

Unable to format SQL:
Error: Parse error: Unexpected "[%album ar" at line 5 column 18

[nene]

Please provide more details, like:

• Which SQL dialect are you using?
• What is this [%title%] syntax? I haven't seen such a thing before. Is it some sort of templating?
• Which version of SQL formatter are you using?
• Also, are you using the library directly, or through some editor plugin, command line tool, web UI, etc?

[nene]

In case this is templating syntax, please see the FAQ

[Aliaksandr3by]

I use foobar2000 + sql

[nene]

So, you're using SQLite. But according to my knowledge this [%title%] thingie is not part of SQLite syntax.

I'm sure it's some sort of templating syntax. Please see the above FAQ link on how to deal with templating syntax.

PS. I have no idea if or how this foobar2000 intergates with SQL formatter.

[Aliaksandr3by]

the one is part of foobar2000 and foo_uie_sql_tree

[nene]

This does not clarify things for me. Perhaps you should search for help from developers of this foobar2000.

[Aliaksandr3by]

I use VS code for SQL, but your program (extension) give to me the
Error: Parse error: Unexpected "[%album ar" at line 5 column 18

I think you might solve it.
e.g.
npp + plugin good working with this code

[nene]

Aha... I realize now that SQLite actually also supports these [...] style quotes. However, so does SQL Formatter.

Looks like you haven't specified SQLite as the dialect that you're formatting.

Again. Please read the FAQ.