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.
1. It lowercases table and field names, rendering the formatted statement useless for a project with not exclusively lowercased names. Could you please fix this?
2. I'd appreciate accepting common placeholder "?" as a valid part of the SQL statement so that we can format queries with placeholders. Would that be possible?