ts-sql-query

ts-sql-query copied to clipboard

Column with type `bigint` not working properly with Oracle NUMBER

1

`oracledb` version is `6.4.0` Table definition: ```ts class Foo extends Table { id = this.column('id', 'bigint') // NUMBER } const tFoo = new Foo(); const bar = await connection .selectFrom(tFoo)...

jameschenjav

Bulk inserts using unnest

2

Hello, Given PostgreSQL has a limit of 65535 params in prepared queries, do you have any plans to implement something like described in this blog post ? https://klotzandrew.com/blog/postgres-passing-65535-parameter-limit

DGCarramona

extract table name

2

Hi. It is possible to extract table name from instance? Something like ```extractTableName(tCustomer)``` // 'customer' ? Thanks

mkupriichuk

Understanding the Purpose of ChainedError in transaction Method in src/connections/AbstractConnection.ts

2

Hello! I'm having trouble understanding the purpose of `ChainedError` in the **src/connections/AbstractConnection.ts** file, specifically in the `transaction` method. In my situation, my services can throw various errors within a transaction,...

kir4ik

union/unionAll static functions

11

It would be nice to have a union/unionAll function that accepts collections of sub queries Example usage: ``` const subQueries = input.blocks.map((block: BlockUpdateInput) => { return conn .selectFrom(tSomeTable) .select({ /*...

lorefnon

dynamicPick ts result type from execute

10

Hi, ```ts import {MySqlConnection} from 'ts-sql-query/connections/MySqlConnection'; import {Table} from 'ts-sql-query/Table'; import pick from 'lodash/pick'; import {SelectedValues, UpdatableValues} from 'ts-sql-query/extras/types'; import {extractColumnsFrom} from 'ts-sql-query/extras/utils'; import {dynamicPick} from 'ts-sql-query/dynamicCondition'; class Connection extends...

kir4ik

ReadStream from executeSelect

10

Hi! I want to export data from MySQL to large csv/json files. I can't store all exported records in RAM and want to use streaming. It will be convenient to...

Smert

Support direct interpolation

4

It is great that the `*FragmentExpression.sql` functions default to converting interpolated values in tagged templates to sql parameters. However, some cases are simplified by enabling direct interpolation. I understand that...

lorefnon

ESM support

4

Would you be open to a PR that exposes es modules in the deployed package as `.mjs` artifacts ? This doesn't need to be a breaking change but likely all...

lorefnon

Representing a complex update/insert/delete CTE

6

Hi, I wanted to ask if the following complex CTE query which comprises of inserts, deletions, and updates could be modeled with this library. Suppose we have a post system...

lithdew