search

brianc / node-sql

SQL generation for node.js
MIT License
1.05k stars 191 forks source link

Generic operators #370

Open hstanford opened 7 years ago

hstanford commented 7 years ago

Adds a generic 'op' method to support operators that currently have no explicit method in node-sql.

Syntax is:

Foo.baz.op('||+')(1)

which produces

"foo"."baz" ||+ 1

This also supports custom unary and ternary operators as

Foo.baz.op('IS EMPTY')()
"foo"."baz" IS EMPTY

and

Foo.baz.op('CAST', 'DEFAULT')('text', 'abcde')
"foo"."baz" CAST 'text' DEFAULT 'abcde'