tree-sitter-sql VS jaffle-shop-classic

Which grammar are you using? https://github.com/DerekStride/tree-sitter-sql supports backticks. This is the one that is used by nvim-treesitter.

A complete grammar of the SQL language is rather large, as can be seen by this grammar https://github.com/DerekStride/tree-sitter-sql/blob/main/grammar.js that is 2000 lines of code.

Alternatively, you could use a tree-sitter parser, such as https://github.com/DerekStride/tree-sitter-sql , which would provide fast incremental parses (but may result in a less detailed AST).

This short article will show how to set up dbt for use with SingleStoreDB. We’ll also quickly apply a dbt example to test the SingleStore dbt adapter.

3.Download jaffle_shop on Github. It is a dbt project for testing maintained by the official

This would be an example SQL file for dbt: https://github.com/dbt-labs/jaffle_shop/blob/main/models/orders.sql

I have been writing SQL for about 15 years, but spent the past 4 using BigQuery and dbt in the ELT framework, and I would 100% recommend this approach versus the traditional ETL workflows. I also highly recommend poking around the dbt website, poking around a simple standard dbt project, and watching some YouTube tutorials. (Not affiliated at all, just a big fan).