Sqlfmt: an opinionated online SQL formatter

Re:Sqlfmt: an opinionated online SQL formatter by stubish on Friday September 28, 2018 @04:22AM (#18091790)

Syntax highlighting is a huge boon working with SQL, but unfortunately you often find you are working with SQL embedded as a string in some other programming language.

I wonder if programming languages should have a way of specifying that a string constant contains embedded code or a template, so text editors can display it accordingly.

I deal with a lot of SQL embedded in code, and prefer uppercase keywords as it seems to help me visually parse the overall file.

[ Parent | on HN ]

Re:Sqlfmt: an opinionated online SQL formatter by QasimK on Friday September 28, 2018 @04:40AM (#18091854)

PyCharm (and likely other editors by Jetbrains) supports embedded programming languages! However, language level support so that this could be automatically done by all editors would be great.

[ Parent | on HN ]

Re:Sqlfmt: an opinionated online SQL formatter by indentit on Friday September 28, 2018 @05:09AM (#18091965)

a lot of programming languages do have a way of specifying that a string constant contains embedded code or a template. Sublime Text for example will look for PHP heredocs with an identifier of XML, HTML, SQL etc. to know what to lex/highlight the string as. Or it will check whether the string starts with an uppercase "SELECT", as the chances are it's gonna be SQL. Code fences in GitHub Formatted Markdown are also a good example of this hinting.

[ Parent | on HN ]