Date Columns Being Inferred as Strings in Script Editor Results

[UmakanthKaspa]

Issue Description:

When using the Script Editor in Frappe Insights to create a query, columns with date values are being inferred as strings instead of the Date type. This creates discrepancies and limits the ability to perform date-related operations. Additionally, integer and other types are correctly inferred, which makes this behavior inconsistent.

---

Steps to Reproduce:

1. Open the Script Editor in Frappe Insights.
2. Use the following Python script to generate results:

results = [
    {
        "employee_id": 101,  # Integer
        "salary": '2023-01-23',  # String value (looks like a date but is a string)
        "join_date": frappe.utils.getdate(frappe.utils.today()),  # Actual date value
    }
]

3. Execute the script and check the inferred types of the columns:
   • employee_id: Correctly inferred as Integer.
   • salary: Correctly inferred as String.
   • join_date: Incorrectly inferred as String instead of Date.

---

Expected Behavior:

• Columns containing actual date values (e.g., join_date) should be inferred as Date or Datetime types, depending on their structure.

---

Observed Behavior:

• The join_date column is inferred as a String type.

---

Screenshot:

---

@nextchamp-saqib

• Is this a bug in Script Editor?
• Should I explicitly cast the data type, or is there a recommended approach to handle this scenario?