Cannot select expression

Question

Cannot select expression

Closed this issue 5 years ago · 2 comments

sql.select(sql.val(123))

The 'this' context of type 'typeof import(".../typed-sql")' is not assignable to method's 'this' of type 'SelectQuery<{}, {}, NoColumnsSelected>'.
  Type 'typeof import(".../typed-sql")' is missing the following properties from type 'SelectQuery<{}, {}, NoColumnsSelected>': _orderBys, _havingCondition, _groupBys, getState, and 23 more.ts(2684)

Answer 1 · 2019-04-14T16:13:47.000Z

When importing select directly, the error is

The 'this' context of type 'void' is not assignable to method's 'this' of type 'SelectQuery<{}, {}, NoColumnsSelected>'.ts(2684)

Answer 2 · 2019-04-14T16:16:23.000Z

Ok turns out the problem is just the location and text of the error message :/

sql.select(sql.val(123).as("tmp"))

works