Jinja SQL/DBT

[kylejbrk]

Check for existing issues

• Completed

Language

SQL

Tree Sitter parser link

Closest I could find: https://github.com/dbt-labs/tree-sitter-jinja2

Language server link

No response

Misc notes

It would be nice to have some DBT support in zed as of right now it all seems to be in vscode. Right now I cant find any official treesitter support. And theres no lsp's available either. It seems most the vscode extensions have their own implementations for syntax highlighting and lsp support.

Syntax Highlighting

At minimum it would be nice to have syntax highlighting for jinja-sql. I tried on my own to merge the 2 existing language supports jinja2 and sql. but it seems like zed really wants a treesitter support per language and cant combine them downstream. Here is vscodes implementation for combining sql and jinja:
https://github.com/samuelcolvin/jinjahtml-vscode

LSP

Even better would be a DBT lsp which seems to be non existent. The logic is baked into the DBT Power User extension and the new official DBT Fusion Extension. Theres also a neovim extension that seems to have some of these features as well. I also found an unofficial dbt lsp here that seems to be early in development.

Taking it further

Having an alternative to DBT Power User and DBT Fusion extensions in vscode for zed would be an ideal solution for us stuck using vscode. Given that the Syntax Highlight and LSP can get implemented, I dont see any blockers for getting something like that implemented. It might even be possible to use parts from DBT fusion given that its written in rust.