thebearingedge/vscode-sql-lit

🎨 Syntax highlighting for SQL template literals.

vscode-sql-lit's Issues

Breaks on *.sql``

We connect to multiple databases, and so sometimes import multiple database objects under different names:

import db from 'src/db'
import herokuDB from 'src/herokuDB'

await db.sql`SELECT 1`
await herokuDB.sql`SELECT 1`

...

This extension works fine with db.sql, but with any other module name, such as herokuDB.sql, JS syntax highlighting breaks after end of the template literal.

/* sql */`SELECT ... Not working for me.

Explain the usage of `sql`

How do I import the sql command is it from another package or what. I'm a bit lost on how to use it and how it can return back the typed value.

Please support deno-postgres

It would be nice to provide support for deno-postgres.

Syntax highlighting breaks with nested sql.array

Hey, thanks for this awesome extension!

I've noticed that sql highlighting fails to properly highlight if there's e.g. an sql.array or sql.join within an sql template string

failing code example:

export function fooFailing() {
  return sql`SELECT (${sql.array([1, 2, 3], 'int8')})`;
}

Support fenced JS and TS code blocks in Markdown.

Not sure how, but it would be dope.

False-positive highlight

Sample code:

const sqlFoo = [];
sqlFoo.push(`)`);
anyFunction();

bar.log(`any other string... but looks like code:1`)

if (error) throw error;
const a = 123;
const c = 456

const s = `broken`;

Preview:

Doesn't work for multiline generic types

Hey, I've found a small issue when highlighting sql with multiline generic types:

as you can see, in testFailing the query is not highlighted (colored as string). This is because the begin span spans multiple lines.

code:

export function testWorking() {
  return sql<{ value: number }>`SELECT 1 AS "value"`;
}

export function testFailing() {
  return sql<{ value: number }
  >`SELECT 1 AS "value"`;
}

No highlighting with slonik sql.type and inline zod schema

Hi! Awesome plugin. I was setting up slonik on a project and noticed that the highlighting doesn't work when I use slonik's sql.type with a custom inline zod schema.

Highlights:

const schema = z.object({ num: z.number() });

sql.type(schema)`
  SELECT 1 as num
`;

Doesn't highlight:

sql.type(z.object({ num: z.number() }))`
  SELECT 1 as num
`;

Thanks so much for this!

Just wanted to come and say thanks for this extension, very cool!

I was using https://github.com/ForbesLindesay/vscode-sql-template-literal up until now, but because of ForbesLindesay/vscode-sql-template-literal#13, moving over here now!

Closing :)

Publish on Open VSX

Hey, this extension looks very interesting!

Would you be open to publishing this extension on Open VSX , so that it can be used e.g. via gitpod?

More information: https://www.gitpod.io/docs/references/ides-and-editors/vscode-extensions#where-do-i-find-extensions

Syntax highlighting breaks if a trigger is at the end of a template string

Whenever a sql-lit highlighted template has an sql-lit trigger at the end of the template, it thinks that there's a new start to a template:

const column = sql`DB_META`