hediet/ts-typed-sql

Issues

• single / singleOrUndefined misleadingly add limit 2 to queries with limit 1 leading to "More than one row returned"

  #41 opened 4 years ago by phiresky
  0

• ISOLATION LEVEL is ignored

  #40 opened 5 years ago by phiresky
  0

• Allow getting result meta information

  #34 opened 7 years ago by phiresky
  1

• Project status?

  #37 opened 6 years ago by pauldraper
  3

• Cannot select expression

  #38 opened 5 years ago by phiresky
  2

• sum() function return type depends on input type

  #36 opened 6 years ago by phiresky
  0

• Broken on non-windows

  #35 opened 7 years ago by phiresky
  1

• Compile with "declaration": true and replace "types": field with declaration

  #33 opened 7 years ago by phiresky
  2

• Put types in their own namespace

  #17 opened 7 years ago by phiresky
  2

• skipQuotingIfNotRequired is buggy

  #31 opened 7 years ago by phiresky
  4

• typescript >= 2.6 compatibility

  #29 opened 7 years ago by phiresky
  2

• or function is missing

  #25 opened 7 years ago by hediet
  1

• .unionAll outputs UNION instead of UNION ALL

  #23 opened 7 years ago by phiresky
  1

• Subquery in insertInto fails with "TypeError: Converting circular structure to JSON"

  #30 opened 7 years ago by phiresky
  0

• Can't match type unknown to int in update from values query

  #7 opened 7 years ago by phiresky
  3

• cast precedence error

  #28 opened 7 years ago by phiresky
  0

• Typed Errors

  #27 opened 7 years ago by phiresky
  0

• whereNot does not respect previous where conditions

  #26 opened 7 years ago by hediet
  0

• Alternative Solution

  #24 opened 7 years ago by vitaly-t
  7

• Move fromItemToOutRow to table instance it self

  #10 opened 7 years ago by phiresky
  2

• SQL query that returns no rows

  #22 opened 7 years ago by phiresky
  1

• between operator

  #21 opened 7 years ago by phiresky
  0

• Allow setting transaction isolation level

  #4 opened 7 years ago by phiresky
  4

• Cannot add date, time, interval, etc.

  #20 opened 7 years ago by phiresky
  0

• CASE expression

  #19 opened 7 years ago by phiresky
  0

• count returns bigint not IntegerType

  #18 opened 7 years ago by phiresky
  0

• FromItemToOutRow

  #8 opened 7 years ago by phiresky
  1

• Add more known function invocations

  #6 opened 7 years ago by phiresky
  2

• oneOrUndefined / singleOrNone

  #16 opened 7 years ago by phiresky
  1

• debug log sql statements using require('debug')

  #12 opened 7 years ago by phiresky
  3

• values params not correctly escaped (uppercase)

  #14 opened 7 years ago by phiresky
  1

• Parameterized queries fail with > 30k params

  #15 opened 7 years ago by phiresky
  0

• Output some warning when doing `x = x`

  #13 opened 7 years ago by phiresky
  0

• tDate is completely broken

  #11 opened 7 years ago by phiresky
  0

• Timestamptz type

  #9 opened 7 years ago by phiresky
  0

• Allow tuples

  #1 opened 7 years ago by phiresky
  2

• tBigInteger should have .add etc.

  #5 opened 7 years ago by phiresky
  0

• Allow SELECT FOR SHARE / FOR UPDATE

  #3 opened 7 years ago by phiresky
  0

• Allow INSERT ... ON CONFLICT *

  #2 opened 7 years ago by phiresky
  0