Feature Question: Any raw sql in ts files are accepted?

[PorcoRosso85]

Hi.
I found this explaination:

https://marketplace.visualstudio.com/items?itemName=senken.sqlsurge

---

Supporting raw SQL query

[Prisma in TypeScript
SQLx in Rust

---

This means that we should use prisma if we want to make ts file autocompleted by vscode?

[senkenn]

@PorcoRosso85 Thank you for issue!!!!!!!!

Any raw sql in ts files are accepted?

Yes!!! I'm planning it in TODOs.

sqlsurge/vsce/README.md

Line 48 in ecd1f3c

- [ ] Support to custom raw SQL queries, not just Prisma and SQLx

sqlsurge use AST to extract raw SQLs, so it is possible to support any ORM libraries or user-defined functions.

I'm considering the vscode settings. For example, there is a code like this,

const result = fooQueryFunc(connection, "SELECT name FROM users WHERE id = 123");

And settings.json,

"sqlsurge.custom": {
  "language": "typescript",
  "function": "fooQueryFunc",
  "templateLiteral": false,
  "argNum": 1 // 0-indexed
}

It would also be possible to handle cases where SQL is split like this,

const baseSql = "SELECT name FROM users";
const condition1 = "WHERE id = 1";
const condition2 = "WHERE id = 2";
const result = fooQueryFunc(connection, baseSql + condition);

I'll support it in the future.

[senkenn]

@PorcoRosso85
I'd like to ask you as a reference, which library are you using? Or your own functions?

[PorcoRosso85]

Own functions, maybe. No orm library.

I'm writing raw sql files as both of DDL and DML,
these files are for 'sqlc comilation for typescript' and 'sqldef migration'

I'm searching one like yours that supports us to write type safed sql in ts file.

[senkenn]

This feature will take time, but I'll do my best to release it soon!

[PorcoRosso85]

By the way,
https://github.com/sqls-server/sqls

will sqls server work any database server if these are live? Do yo know?
https://github.com/sqls-server/sqls?tab=readme-ov-file#support-rdbms

[senkenn]

@PorcoRosso85
I checked MySQL, Postgres only, sorry.

[PorcoRosso85]

@senkenn

Enough.

If we use postgres, is what we only have to do is connecting live postgres server for sqls to suggest auto completion?

sqlsurge doesn't require these as sqls doc explaining?

MySQL(Go-MySQL-Driver)
PostgreSQL(pgx)
SQLite3(go-sqlite3)
MSSQL(go-mssqldb)
H2(pgx)
Vertica(vertica-sql-go)

[senkenn]

@PorcoRosso85 Yes, connection only.

[senkenn]

@PorcoRosso85 I created new issue about this: #66