News for hackers. Stuff that matters.
Re:Sqlfmt: an opinionated online SQL formatter by mjibson on Thursday September 27, 2018 @05:53PM (#18089112)
The formatter adheres to CockroachDB rules which is why it acts like you describe. Case is insensitive in names unless you double quote it. Postgres-style (CockroachDB is one) uses "$1" for placeholders instead of "?". Adding "?" would complicate our grammar enough that it's not worth adding it.

sqlfmt is not super useful for non-postgres grammars.

Re:Sqlfmt: an opinionated online SQL formatter by egorfine on Friday September 28, 2018 @07:21AM (#18092509)
I understand it about placeholders. Fair enough. I can do quick s/\?/\$1/g, no prob.

Still how about not lowercasing identifiers? This is actually a blocker, I'm sure you see it:)

Re:Sqlfmt: an opinionated online SQL formatter by crooked-v on Thursday September 27, 2018 @08:46PM (#18090144)
Consider those of us stuck with Java adapters to Postgres, which means Postgres syntax but ? for placeholders.
Re:Sqlfmt: an opinionated online SQL formatter by mjibson on Thursday September 27, 2018 @10:45PM (#18090596)
Is that a thing? The Java driver must actually parse those and convert them. Java is crazy. https://github.com/mjibson/sqlfmt/issues/25 is the issue to track '?' as placeholders.
Re:Sqlfmt: an opinionated online SQL formatter by lilactown on Friday September 28, 2018 @01:40AM (#18091308)
It might be crazy, but having just gotten my hands dirty with some seriously DB programming, JDBC has a hell of a lot of value in my view.