Export parsed structure to JSON

[ispmarin]

Is it possible to export the parsed structure to JSON, similar to pglast does?

[akeeman]

Source:

import json
import psqlparse

query = "SELECT * FROM my_table"

json_str = json.dumps(psqlparse.parse_dict(query), sort_keys=True, indent=4)
print(json_str)

Result:

[
    {
        "SelectStmt": {
            "fromClause": [
                {
                    "RangeVar": {
                        "inhOpt": 2,
                        "location": 14,
                        "relname": "my_table",
                        "relpersistence": "p"
                    }
                }
            ],
            "op": 0,
            "targetList": [
                {
                    "ResTarget": {
                        "location": 7,
                        "val": {
                            "ColumnRef": {
                                "fields": [
                                    {
                                        "A_Star": {}
                                    }
                                ],
                                "location": 7
                            }
                        }
                    }
                }
            ]
        }
    }
]