codeant-ai-for-open-source[bot] commented on PR #38172:
URL: https://github.com/apache/superset/pull/38172#issuecomment-4041072805
## **Sequence Diagram**
This PR updates the result set conversion flow so that nested JSON and array
columns are tracked during PyArrow table construction and then restored as
Python dicts/lists when building the pandas DataFrame, while safely handling NA
detection, ensuring templates and API consumers receive real JSON objects
instead of stringified values.
```mermaid
sequenceDiagram
participant QueryExecutor
participant ResultSet
participant PyArrow
participant Pandas
participant TemplateEngine
QueryExecutor->>ResultSet: Initialize with DB rows including JSON
ResultSet->>PyArrow: Build column arrays
PyArrow-->>ResultSet: Indicate nested types or error
ResultSet->>ResultSet: Track nested columns and stringify for table
QueryExecutor->>ResultSet: Request pandas DataFrame
ResultSet->>Pandas: Convert table to DataFrame
ResultSet->>Pandas: Restore nested columns as Python objects
Pandas-->>TemplateEngine: Provide records with JSON preserved and NA
handled
```
---
*Generated by [CodeAnt AI](https://codeant.ai)*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]