SQL style guide by Simon Holywell

Re:SQL style guide by Simon Holywell by mijamo on Friday November 15, 2024 @07:27AM (#42146286)

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.

[ Parent | on HN ]

Re:SQL style guide by Simon Holywell by eddd-ddde on Friday November 15, 2024 @12:45PM (#42149133)

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

[ Parent | on HN ]

Re:SQL style guide by Simon Holywell by emmelaich on Friday November 15, 2024 @09:20PM (#42153581)

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

```sql

```

[ Parent | on HN ]

Re:SQL style guide by Simon Holywell by dagss on Thursday November 21, 2024 @12:13PM (#42206390)

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..

[ Parent | on HN ]