Incorrect SQL Query Generation for Nested JSON Fields

[qazi9amaan]

Description
I am using react-awesome-query-builder to create a query to fetch users with paymentStatus = 'Refunded' stored in a nested JSON column lastOrder. The configuration uses !struct for nested objects.
However, the generated SQL query is incorrect:.

lastOrder.paymentStatus = 'Refunded';

This SQL query does not work as expected with JSON columns.

Steps to reproduce

• Use the following query configuration:

{
  "label": "Last Order",
  "subfields": {
    "paymentStatus": {
      "label": "Payment Status",
      "listValues": {
        "Pending": "Pending",
        "Paid": "Paid",
        "Refunded": "Refunded"
      },
      "type": "select",
      "valueSources": [
        "value"
      ]
    },
    "orderStatus": {
      "label": "Order Status",
      "listValues": {
        "Pending": "Pending",
        "Delivered": "Delivered",
        "Cancelled": "Cancelled",
        "Returned": "Returned"
      },
      "type": "select",
      "valueSources": [
        "value"
      ]
    }
  },
  "type": "!struct"
}

• Create a query to filter lastOrder.paymentStatus = 'Refunded'.
• Observe the generated SQL query.

Example JSON Tree:
This is how the JSON tree looks

{
  "id": "a8999ba8-0123-4456-b89a-b190fa823c98",
  "type": "group",
  "path": [
    "a8999ba8-0123-4456-b89a-b190fa823c98"
  ],
  "children1": {
    "a89bbb88-4567-489a-bcde-f190fa84d826": {
      "type": "rule",
      "id": "a89bbb88-4567-489a-bcde-f190fa84d826",
      "properties": {
        "fieldSrc": "field",
        "field": "lastOrder.paymentStatus",
        "operator": "select_equals",
        "value": [
          "Refunded"
        ],
        "valueSrc": [
          "value"
        ],
        "operatorOptions": null,
        "valueType": [
          "select"
        ],
        "valueError": [
          null
        ]
      },
      "path": [
        "a8999ba8-0123-4456-b89a-b190fa823c98",
        "a89bbb88-4567-489a-bcde-f190fa84d826"
      ]
    }
  }
}

Expected Behavior:
The generated SQL query should correctly handle the nested JSON field:

json_extract(lastOrder, '$.paymentStatus') = 'Refunded';

Current Behavior:
The generated SQL query is:

lastOrder.paymentStatus = 'Refunded';