Predicate with parameter the same as a table column name

[Davidvlv]

Hi, how are you supposed to deal with reserved words for column names?

We are creating our predicates like:

let name = "test";
Predicate.create("Name", "contains", name);

The above works when the name variable is something random, but if it happens to be the same as the name of a column, e.g. "Id", then the SQL generated is something like:

SELECT * FROM Table WHERE Name = Id

Instead of

SELECT * FROM Table WHERE Name = 'Id'

How do we create the predicate in a way that the third parameter can overlap a column name?

[steveschmitt]

I think the syntax is

let name = "test";
Predicate.create("Name", "contains", { value: name, isProperty: false });

but this probably only works with breeze-client 2.0 or newer.