4 ms·
Intellij tools are capable to parse, lint, and autocomplete sql in strings. To my own surprise, it has become my favorite way to handle queries with multiple/v
by roselan 9y ago
Intellij tools are capable to parse, lint, and autocomplete sql in strings.
To my own surprise, it has become my favorite way to handle queries with multiple/variable joins.
- dotancohen 9y agoAlso, in languages that support HEREDOCS, if you call the HEREDOC "SQL" then VIM and the Intellij editors will syntax-highlight the SQL.
- roselan 9y agoIt's not only that: It connects to your database an you have autocompletion for tables, columns and any schema objects, as well as linting. All that inside any string. By example: $sql = "select myColFromTableB from tableA"; Inspection will give you have a "unknown column" warning. (ps: sorry for late reply)
- dotancohen 9y agoThank you, I did not know that! It is not working for me, but I'll poke and peek around for a setting.