node-sql-template-strings

node-sql-template-strings copied to clipboard

Helper for join array of SQLStatements?

5

Just ran into this: need to join array of condition parts with `and` separator: ```ts // I have this: const parts: SQLStatement[] = [ SQL`a = ${value1}`, SQL`b = ${value2}`,...

Strate

I'm trying to extend the class in my TS project, but the lack of constructor prevents me from constructing the child class. 

fadillzzz

Add .appendAll() function

8

Adds an .appendAll() function that allows you to pass an array of statements or strings to append. You can also provide a custom delimiter to separate the statements/strings (defaults to...

KaidenR

Append sql without modifying the original sql

1

The `append` method will modify the original sql in place. However, it's common that we need to define a common base sql (as const), and append different `WHERE` or `ORDER...

guoqiao

Cleaner approach possible for append?

12

If I want to use `append` because I want to have a dynamic column name (e.g. `othercolumn1`, `othercolumn2`), it looks like this. ```js return sqlTemplateString` update thetable set thecolumn1 =...

rightaway

This is relevant for MySQL and MariaDB that don't have a native boolean type. Not sure about Postgres

whitebyte

Question: Is there any syntax highlighting extension for vscode?

7

Are there any already existing plugin which makes possible syntax highlighting for vscode? Is it possible to convert the sublime one?

DJviolin

Binding with IN operator

5

We are trying to use useBind() with a sequelize `IN` raw query going to MSSQL. This works great if `status` has one element. However, when there are multiple elements in...

gavinbelson

DblK

sqlite3 support?

2

`sqlite3` is not mentioned in the Works with list. Is there a plan for support?

MatthijsKok