Hacker News Reader

HNHacker News

Top New Best Ask Show Jobs

Comment by emmelaich | Hacker News Reader

Parent Full thread

emmelaich·

Also, could uppercase go away and never come back? Please?

View on HN

but why? it's a quick and easy way to distinguish commands from arguments

Why do you not make that argument for "if" and "else" in Go/Java/...?

Editors highlight syntax.

Editors don’t syntax highlight SQL queries written as strings. That’s the main reason I write my queries with uppercase keywords in my Go programs

Editors can highlight SQL queries embedded as strings. Neovim can do it, and I'm pretty confident it's not going to be alone in that respect.

edit: Not the editor I use but thought it might be helpful. Here is an extension, which I haven't tested, to do this in VSCode: https://marketplace.visualstudio.com/items?itemName=iuyoy.hi...

I have never seen a syntax highlighter for SQL that actually covers the real deal from Postgres dialect. Basic stuff is covered and then suddenly you use a combination that isn't covered and the colors are all wrong. This is even true for pgadmin, which is ironic. Unlike most programming languages, SQL built in syntax is huuuuuge and it is very hard to cover it all, especially as it varies with the dialect.

I use Jetbrains and there is at least full coverage for MSSQL in my experience, which is a huge dialect -- not only syntax highlighting but full IDE features like autocompletion and target name refactoring etc.

And 10 other dialects are listed..

Maybe it's time for programming languages for use something like markdown in strings for embedded sql and dsl. e.g.

```sql

```

Any jetbrains IDE with sql tools will work perfectly in my experience.

That would be a nice change too. Also THEN, BEGIN, END to replace varous brackets.

Reply on news.ycombinator.com