DEV Community

Discussion on: Dynamically generating SQL queries using Node.js

View post

Replies for: Thanks. What about optional ORDER BY? For WHERE you started with TRUE so the absence of conditions results in WHERE (true) which is syntactically c...

 
gajus profile image
Gajus Kuizinas • 
${sort ? sql`ORDER BY ${makeOrder(sort)}` : sql``}
Enter fullscreen mode Exit fullscreen mode
Thread Thread
 
ivan_paqmind profile image
Ivan Kleshnin •

Causes

InvalidInputError: Unexpected SQL input. Query cannot be empty.
Thread Thread
 
gajus profile image
Gajus Kuizinas • 
sql`--`
Thread Thread
 
gajus profile image
Gajus Kuizinas •

I cannot recall the original reason for this constraint. Will likely remove this constraint. Track github.com/gajus/slonik/issues/93.