Improve textmate scopes for Jinja-SQL

[moseleyi]

I have been trying to change the token colours in SQL files that are marked as Jinja SQL, which is used, for example, by dbt or Dataform. Unfortunately, the scopes do not make sense in a way that I could style them in settings.

For examples here is just a part of a normal SELECT

For this one, the scope of the column name says it's a table name, which clearly it's not

And instead of recognising table name it thinks that "calcs" is database name

And subsequent SELECT without table alias in front of the fields

I can't find a good way of changing the way those files look like.