juanluispaz/ts-sql-query
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.
TypeScriptMIT
Issues
- 10
ReadStream from executeSelect
#96 opened by Smert - 2
order by specify ids
#129 opened by mkupriichuk - 2
Feature Request: ReadOnlyQueryRunner
#128 opened by thekevinbrown - 2
- 1
- 2
aggregateAsArray with distinct columns
#125 opened by threema-danilo - 6
Add QueryRunner for sqlite3 wasm implementation
#107 opened by melink14 - 11
Error "Forbidden concurrent usage of the query runner was detected when it tried to get a database connection from the pool"
#123 opened by DGCarramona - 2
How to integrate ts-sql-query with migrations?
#113 opened by Motii1 - 1
AES_ENCRYPT and AES_DECRYPT
#114 opened by mkupriichuk - 2
- 3
Optional column contextually mandatory
#118 opened by DGCarramona - 2
Access to system columns
#120 opened by DGCarramona - 2
[Question] Advanced time types
#121 opened by DGCarramona - 6
Should the selected type for stringInt column be string instead of string | number ?
#108 opened by lorefnon - 2
Bulk inserts using unnest
#119 opened by DGCarramona - 5
Custom date types & `AbstractConnection.current{Date,DateTime,Time,Timestamp}()`
#122 opened by beverloo - 2
extract table name
#116 opened by mkupriichuk - 3
Error on subSelect when picking just one value
#110 opened by leosuncin - 2
Understanding the Purpose of ChainedError in transaction Method in src/connections/AbstractConnection.ts
#115 opened by kir4ik - 9
deleteAllowingNoWhereFrom question
#103 opened by mkupriichuk - 14
is it possible to return null instead of nothing when using a nullable column in a table
#84 opened by kir4ik - 2
optionalJoin+inIfValue behaves unexpectedly in presence of unrelated leftJoin
#112 opened by lorefnon - 11
union/unionAll static functions
#77 opened by lorefnon - 2
Oracle Procedure Out Params
#106 opened by platzhersh - 2
What's the recommended way of tracking errors?
#111 opened by beverloo - 3
Connection-string for mssql.
#109 opened by runar-rkmedia - 2
Invalid localDate value to send to the db
#105 opened by guzmanf - 4
nested transactions
#104 opened by kir4ik - 16
- 2
Add support for using table column in orderBy
#102 opened by kir4ik - 2
Error in connection.rollback
#101 opened by Smert - 24
Are there plans to support Oracle dialect specific hierarchical queries (connect by)?
#98 opened by platzhersh - 10
dynamicPick ts result type from execute
#86 opened by kir4ik - 8
Update multiple tables in one query
#82 opened by Smert - 2
- 9
Infinite loop in query builder
#97 opened by Smert - 2
subquery inside inIfValue
#95 opened by mkupriichuk - 2
column with decimal type
#94 opened by mkupriichuk - 6
`AbstractSqlBuilder` generates incorrect `case` statement for boolean type
#90 opened by jameschenjav - 7
strict type for insert on duplicate key update
#85 opened by kir4ik - 5
avoid "?" on query when value is const
#83 opened by mkupriichuk - 4
Support direct interpolation
#89 opened by lorefnon - 2
- 2
- 2
- 2
- 2
- 1
Using the json data type
#76 opened by ibox4real - 5