Enable sql syntax highlighting in multiline strings that start with a --sql comment

[saolof]

A somewhat common way to identify a multiline string as an sql string for editor support is something like this:

foo = """--sql
    select foo from bar
"""

(example: https://github.com/barklan/inline_sql_syntax )

It would be neat to have this or equivalent support for syntax highlighting in helix, which has otherwise been more or less perfect for me out of the box and has become my goto editor.

[the-mikedavis]

Injections are the right tool for this for languages with tree-sitter grammars: https://tree-sitter.github.io/tree-sitter/syntax-highlighting#language-injection

Supporting this for plaintext is out of scope though, it should be limited to languages with tree-sitter grammars.

[danillos]

I did it for Ruby here, it could help you to implement in other languages.

[johan-lejdung]

I did this to go simply by adding a file ~/.config/helix/runtime/queries/go/injections.scm with the contents:

((
  (raw_string_literal) @constant
  (#match? @constant "(SELECT|select|insert|INSERT).*")
)@injection.content (#set! injection.language "sql"))

Extend to include as many keywords as you'd like :) Give it a go!