ts-sql-query
ts-sql-query copied to clipboard
Type-safe SQL query builder like QueryDSL or JOOQ in Java or Linq in .Net for TypeScript with MariaDB, MySql, Oracle, PostgreSql, Sqlite and SqlServer support.
With ts-sql-query 1.64.0, given these table definitions with compatible columns `a` and `b`: ```ts const tFoo = new (class TFoo extends Table { public uid = this.autogeneratedPrimaryKey('uid', 'bigint'); public a...
Hi When using the _mysql2_ driver and executing an INSERT query with `returningLastInsertedId`, I encounter the following behavior: - If I insert a single record, the ID is returned as...
Hi, I want to execute the following SQL statements: ``` SET @cur_pos = 0; UPDATE table SET position = (SELECT (@cur_pos := @cur_pos + 1000)) WHERE tableId = 3570 ORDER...