how to build sql with "OR", "LIKE" word. about json-sql

[artzhookov]

builder.build({
  type: 'select',
  table: 'table',
  fields: ['a'],
  condition: {
    $or: [
      { b: 1 },
      { c: 1 }
    ]
  }
});

builder.build({
    type: 'select',
    table: 'table',
    fields: ['a'],
    condition: {
        b: 1,
        c: 1,
        $or: [
          { d: { $like: 'dd' } },
          { e: { $like: 'ee' } }
        ]
    }
});

[flowercodec]

Thanks
first one worked.
second seem something error.
sql.query show follow
select "a" from "table" where "b" = 1 and "c" = 1 and ("d" like $p1 or "e" like $p2);
$p1 $p2 replace the 'dd' and 'ee'

[flowercodec]

miss separatedValues : false option

[artzhookov]

OK, but it is not safe coz separatedValues: false enable potential SQL injections.

[flowercodec]

if set separatedValues : true, how to use sql text with "$p1 $p2" ,I use node msql(npm install mysql)
I didn't want potential SQL injections. :(