You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Describe the bug
SafeQL throws multiple errors when using the sql tagged template string on Postgres, which leads to the errors below Invalid Query: the type "string | PendingQuery<Row[]>" is not supported and Invalid Query: Error: syntax error at or near "DEFAULT" The query below will throw the above errors
exportasyncfunctionquery(a: number,b: string,c: string){returnawaitsql` UPDATE try_safe_ql SET b = ${b}, c = ${c||sql`DEFAULT`} WHERE a = ${a} `;}
To Reproduce
Steps to reproduce the behavior:
Setup SafeQL
Use this code in .ts file
exportasyncfunctionquery(a: number,b: string,c: string){returnawaitsql` UPDATE try_safe_ql SET b = ${b}, c = ${c||sql`DEFAULT`} WHERE a = ${a} `;}
Expected behavior
There shouldn't be an error when using sql tagged template string
**
Screenshots**
Desktop (please complete the following information):
OS: MAC OS
PostgreSQL version 14
Version [e.g. 22]
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered:
Describe the bug
SafeQL throws multiple errors when using the
sql tagged template string
onPostgres
, which leads to the errors belowInvalid Query: the type "string | PendingQuery<Row[]>" is not supported
andInvalid Query: Error: syntax error at or near "DEFAULT"
The query below will throw the above errorsTo Reproduce
Steps to reproduce the behavior:
.ts
fileExpected behavior


There shouldn't be an error when using
sql tagged template string
**
Screenshots**
Desktop (please complete the following information):
Additional context
Add any other context about the problem here.
The text was updated successfully, but these errors were encountered: