gistfile1.txt

> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q | from-json | get results.travel-sample | sort-by name
━━━━━━━━━━┯━━━━━━━━━━━━━━━┯━━━━━━┯━━━━━━┯━━━━┯━━━━━━━━━━━━━┯━━━━━━━━━
 callsign │ country       │ iata │ icao │ id │ name        │ type
──────────┼───────────────┼──────┼──────┼────┼─────────────┼─────────
 MILE-AIR │ United States │ Q5   │ MLA  │ 10 │ 40-Mile Air │ airline
━━━━━━━━━━┷━━━━━━━━━━━━━━━┷━━━━━━┷━━━━━━┷━━━━┷━━━━━━━━━━━━━┷━━━━━━━━━

> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q | from-json | get results | get travel-sample | sort-by name
━━━┯━━━━━━━━━━━┯━━━━━━━━━━━━━━━━┯━━━━━━┯━━━━━━┯━━━━━━━┯━━━━━━━━━━━━━━━━━━━━━━━━┯━━━━━━━━━
 # │ callsign  │ country        │ iata │ icao │ id    │ name                   │ type
───┼───────────┼────────────────┼──────┼──────┼───────┼────────────────────────┼─────────
 0 │ MILE-AIR  │ United States  │ Q5   │ MLA  │    10 │ 40-Mile Air            │ airline
 1 │ REUNION   │ France         │ UU   │ REU  │  1191 │ Air Austral            │ airline
 2 │ AIRLINAIR │ France         │ A5   │ RLA  │  1203 │ Airlinair              │ airline
 3 │ ACE AIR   │ United States  │ KO   │ AER  │   109 │ Alaska Central Express │ airline
 4 │ FLYSTAR   │ United Kingdom │ 5W   │ AEU  │   112 │ Astraeus               │ airline
 5 │ atifly    │ United States  │ A1   │ A1F  │ 10226 │ Atifly                 │ airline
 6 │           │ United Kingdom │      │ JRB  │ 10642 │ Jc royal.britannica    │ airline
 7 │ LOCAIR    │ United States  │ ZQ   │ LOC  │ 10748 │ Locair                 │ airline
 8 │ SASQUATCH │ United States  │ K5   │ SQH  │ 10765 │ SeaPort Airlines       │ airline
 9 │ TXW       │ United States  │ TQ   │ TXW  │ 10123 │ Texas Wings            │ airline
━━━┷━━━━━━━━━━━┷━━━━━━━━━━━━━━━━┷━━━━━━┷━━━━━━┷━━━━━━━┷━━━━━━━━━━━━━━━━━━━━━━━━┷━━━━━━━━━

gistfile2.txt

> cbq -u Administrator -p password --script "select * from `travel-sample` limit 10" -q
{
    "requestID": "17b6efa4-a9f9-4949-b706-21a0d7f94610",
    "signature": {
        "*": "*"
    },
    "results": [
        {
            "travel-sample": {
                "callsign": "MILE-AIR",
                "country": "United States",
                "iata": "Q5",
                "icao": "MLA",
                "id": 10,
                "name": "40-Mile Air",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "TXW",
                "country": "United States",
                "iata": "TQ",
                "icao": "TXW",
                "id": 10123,
                "name": "Texas Wings",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "atifly",
                "country": "United States",
                "iata": "A1",
                "icao": "A1F",
                "id": 10226,
                "name": "Atifly",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": null,
                "country": "United Kingdom",
                "iata": null,
                "icao": "JRB",
                "id": 10642,
                "name": "Jc royal.britannica",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "LOCAIR",
                "country": "United States",
                "iata": "ZQ",
                "icao": "LOC",
                "id": 10748,
                "name": "Locair",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "SASQUATCH",
                "country": "United States",
                "iata": "K5",
                "icao": "SQH",
                "id": 10765,
                "name": "SeaPort Airlines",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "ACE AIR",
                "country": "United States",
                "iata": "KO",
                "icao": "AER",
                "id": 109,
                "name": "Alaska Central Express",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "FLYSTAR",
                "country": "United Kingdom",
                "iata": "5W",
                "icao": "AEU",
                "id": 112,
                "name": "Astraeus",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "REUNION",
                "country": "France",
                "iata": "UU",
                "icao": "REU",
                "id": 1191,
                "name": "Air Austral",
                "type": "airline"
            }
        },
        {
            "travel-sample": {
                "callsign": "AIRLINAIR",
                "country": "France",
                "iata": "A5",
                "icao": "RLA",
                "id": 1203,
                "name": "Airlinair",
                "type": "airline"
            }
        }
    ],
    "status": "success",
    "metrics": {
        "elapsedTime": "2.12109ms",
        "executionTime": "2.034246ms",
        "resultCount": 10,
        "resultSize": 3002
    }
}