CSNW / sql-bricks

Transparent, Schemaless SQL Generation
http://csnw.github.io/sql-bricks
MIT License
203 stars 25 forks source link

parametrised queries with array values #98

Open cybermerlin opened 6 years ago

cybermerlin commented 6 years ago
await db.raw("select * from pupi where pop = $1::BIGINT AND stones && $2", [
            userId,
            [['2','3', '11111']]
        ]).run()

need in $2 as ARRAY[ '2', '3', '11111']::text[]