Issues with object/column name "primary" in Query JSON with SQL

Queries and Resources
1

Does anyone have an idea why I'm getting errors around trying to query on the column "primary" in the following data set?

Example data set from allServers:

[
  {
    "id": 313,
    "hostname": "hostname1",
    "serverType": "AS",
    "primary": true,
    "environmentType": "PROD"
  },
  {
    "id": 785,
    "hostname": "hostname2",
    "serverType": "XSP",
    "primary": false,
    "environmentType": "PROD"
  }
]

Query of the Resource "Query JSON with SQL":

SELECT * FROM {{allServers.data}} as stuff
WHERE stuff.serverType = 'AS' 
  AND stuff.primary = 'true'

The error shown when the query is run with "Preview":

message:"Parse error on line 3:
...= 'AS'   AND stuff.primary = 'true'
----------------------^
Expecting 'LITERAL', 'BRALITERAL', 'VALUE', 'STAR', got 'PRIMARY'"

Many thanks!

2

I was able to figure it out with help from our internal team - "primary" is a reserved word, so it needs special treatment, e.g.

SELECT * FROM {{allServers.data}} as stuff
WHERE stuff.serverType = 'AS' 
  AND stuff.[primary]
3