Any idea how to enable querying YAML/JSON AaC and return a tabular report?

[SlavaVedernikov]

I'm thinking of a feature where SQL-like query can be passed to the CLI and a tabular result would be returned.

For example:
GIVEN the following AaC in JSON

{
    "BigBankPlc": {
        "SoftwareSystems": {
            "EMailSystem": {
                "Boundary": "External",
                "Label": "E-Mail System"
            },
            "InternetBanking": {
                "Boundary": "Internal",
                "Containers": {
                    "APIApplication": {
                        "ContainerType": "Api",
                        "Label": "API Application"
                    },
                    "Database": {
                        "ContainerType": "Database",
                        "Label": "Database"
                    },
                    "MobileApp": {
                        "ContainerType": "Mobile",
                        "Label": "Mobile App"
                    },
                    "SinglePageApp": {
                        "ContainerType": "Spa",
                        "Label": "Single-Page App"
                    },
                    "WebApplication": {
                        "ContainerType": "WebApplication",
                        "Label": "Web Application"
                    }
                },
                "Label": "Internet Banking"
            },
            "MainframeBankingSystem": {
                "Boundary": "External",
                "Label": "Mainframe Banking System"
            }
        }
    }
}

WHEN I pass the following SQL query:

SELECT Label, Alias, Containers.Count AS [Number of Containers]
FROM BigBankPlc.SoftwareSystems.*
WHERE Boundary = "Internal"

THEN the following tabular result is returned

Label	Alias	Number of Containers
Internet Banking	BigBankPlc.SoftwareSystems.InternetBanking	5

And WHEN I pass the following SQL query:

SELECT Label AS [Software System], Alias AS [Software System Alias], Containers.*.Label AS [Container], Containers.*.Alias AS [Container Alias]
FROM BigBankPlc.SoftwareSystems.*
WHERE Boundary = "Internal" AND Containers.*.ContainerType = "Api"

THEN the following tabular result is returned

Software System	Software System Alias	Container	Container Alias
Internet Banking	BigBankPlc.SoftwareSystems.InternetBanking	API Application	BigBankPlc.SoftwareSystems.InternetBanking.Containers.APIApplication