Invalid field in the COQL query

Invalid field in the COQL query

Dear Zoho Support!
I believe that you already helped me with a similar problem a few years ago.

One of my clients has a custom field named "LOB" in the "Deals" Module (see the field's metadata below).

The COQL query using this field:
  1. : "select id, Deal_Name, LOB FROM Deals WHERE (id is not null) LIMIT 1"
Fails with the message
  1. {
        "code": "SYNTAX_ERROR",
        "details": {
            "line": 1,
            "column": 23,
            "near": "LOB"
        },
        "message": "error occured while parsing the query",
        "status": "error"
    }

If I remove the "LOB" from the query, it will be executed as expected.
Can you please resolve this issue? Thank you!


The LOB field's metadata (I removed the picklist values for privacy) :
  1. {
      "system_mandatory": false,
      "webhook": true,
      "json_type": "string",
      "crypt": null,
      "field_label": "LOB",
      "tooltip": null,
      "range": null,
      "created_source": "default",
      "display_format_properties": null,
      "field_read_only": false,
      "display_label": "LOB",
      "ui_type": 2,
      "read_only": false,
      "association_details": null,
      "quick_sequence_number": "6",
      "businesscard_supported": true,
      "currency": {},
      "id": "458204000000268089",
      "custom_field": true,
      "lookup": {},
      "visible": true,
      "address": null,
      "length": 120,
      "view_type": {
        "view": true,
        "edit": true,
        "quick_create": true,
        "create": true
          },
      "subform": null,
      "external": null,
      "api_name": "LOB",
      "parent_field": null,
      "display_format": null,
      "unique": {},
      "history_tracking": false,
      "data_type": "picklist",
      "child_fields": null,
      "formula": {},
      "decimal_place": null,
      "mass_update": false,
      "blueprint_supported": true,
      "multiselectlookup": {},
      "auto_number": {}
    }
When my code